A new problem conerning message boxes please help

[RichardFong]

Hi, i thought i had found the answer to the problem i just posted about creating a message box where the user has an option to continue, for example 'Are you sure you want to quit' and the user could selct ok or cancel. I was unable to get this to work at all.


I also have a second problem in the booking ystem, becuase i have a table names 'date_tbl' containing a 'date_id' field, 'date' field, and an 'unavailable' field. The unavailable field is simply a yes/no checkbox, so certain dates can be selected as unavailable. I have created a form where the user can create a new booking, and the form shows the unavailable tickbox so the user can see whether it is avaiable or not. I wanted an error message to appear when the user clicked the command button to save the booking though.

the only information i could find on this topic on the forum is shown below, but i was unsure how apply it to my database.

Basically in the CONDITION of a macro, have it use Dlookup and pull the Qty On Hand left on the item, and if it is less than 5 do a msgbox command.

Forms!Form1![ItemNo] contains the item number for this example

Dlookup("OHQty","ItemTable","ItemNumber = " & Forms!Form1![ItemNo]) < 5

Would be in the Condition, the statment would be MsgBox

Something like this any way.

thanks for the help

 

[Mile-O]

Double Post