Update a table field when a date is reached

M

matty ratafairy

Hello, I'm hoping you can help. I've tried searching and searching but.......

I want to update the Status of an order firstly, when certain checkboxes are
ticked and, after all the check boxes are ticked, when a certain date is
passed. So I can then make a report of orders by current status.

Satus Table :
Status ID Autonumber
OrderID From Orders Table
NewEnq Y/N
DepositPaid Y/N
OrderConfirmed Y/N
PaidInFull Y/N
IDStatusNow From StatusNow Table

Orders table has OrderID,......, StartDate,EndDate fields

StatusNow table :
IDStatusNow Autonumber
StatusNow (1) New Enq,(2) Deposit Paid, (3) OrderConfirmed, (4) Paid In
Full, (5) Order In Process and (6) Order Finished

So, at the moment I have an orders form with the status as a subform. with
an event procedure for clicking the checkboxes:

Me.IDEstadoNow = Null
Me.IDEstadoNow.Requery
Me.IDEstadoNow = Me.IDEstadoNow.ItemData(3) for example

this all works ok. It is once all the tickboxes are checked that I don't
know how to proceed.
I need the status in the Status table to change to (5) when todays date is
between start and end Dates and to (6) when End Date has passed.

I hope I made that clear and thanks in advance.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Make a field mandatory when another one changes 2
Table Relationships 0
Form from a query 1
date calculation in pivot table to show products over agreed date? 0
Update field in table 5
Average of a Date Field 2
Report based on multiple query's 3
Multiple Headers Through-out document when Importing Text File 0

Top