Date Related Validation

[ldare2000]

Hi,

I'm teaching the WJEC Applied ICT A2 assignment and there's one thing my students need to do which I am unsure of myself.

The assignment is based on a Car Auction and between Tuesday and midday Wednesday traders can enter bids using a forms and the bids table. How could I enter a validation rule that would only allow entried between these times?

Would I set the default value in the table as =date()
But how could I set the validation in the form ? Would it take Between 0:00:00 Tuesday until 12:00 Wednesday?



Thanks in advance
Louis

[NTC]

I don't think you want to do this in the form property. The valid bid period is changing from auction to auction or item to item or something like that - it is not fixed one time forever...

I think you want unbound text boxes in your form (which ultimately you can make not visible once this is all working). One would be =Now() which sets the current time...others for BidPeriodStart and BidPeriodEnd - am not sure where those values come from or whether they already exist in the record..... but in any case once the user puts in some entry in any field - in your AfterUpdate event you do this time comparison - - and go from there....