Search results

Sorry i really cant follow what to do, I dont know how to make it a combo box, because its an autonumber? Any ideas and im not sure if that code works What does the me! part represent? Thanks again

The form option sounds best what code would i use thanks for the help

Hi there, I have a table called Cars and a table called Rent In Cars i have Car ID (Autonumber and primary Key) and Price Per Day In Rent I have Rent ID, Car ID and Price Per day The Car ID in Rent is a lookup from the Cars table, but is it possible to make it so that when i enter the Car...

Genius, cheers m8 that worked perfect, these are great forums

How would i do it in a form? Thanks Edit: OK i do know how to do it but it comes up with Control Cannot be edited; it's bound to the expression '=DateDiff("d",[Date Booked From],Date())<=5' Edit: That was my own fault i was putting it in the control source and not the validation rule. BUt...

Hi there, just a quick question really. I have got a start date and an end date field in a table both in Date/Time data type. Can i validate the end date so that it cannot be longer than 5 days after the start date, that has been entered. Or is this impossible to do in a table? Thanks for any help