Hi guys,
I know that this is going to be a pathetic question, but I do not usually handle anything to do with my works Access 2000 Database.
My boss wants a new error reporting tool that pops up a message saying that a machine is already booked out when trying to book it out to a client. I have used a Macro to create the message, however, the way that the forms are designed makes the message pop up when we are trying to return the item using a Ctrl F - Find and Replace.
The database consits of 1 window that allows us to book out and return in the same form/subform.
Could someone help me with some code that would replace this Macro.
The Macro I have is -
([Forms]![Equipment lending Query 2]![Equipment lending Query 2 subform].[Form]![Return Date]) Is Null MsgBox
I know this is not much to go on, but if anyone can help, I am able to send screen shots etc. I havent touched access in about 12 years and it sounded so simple.... But being such a simple database, its now becoming too complicated for me.
In the end, I just want a message box to appear once. Then when OK is clicked I dont want it popping back up when Ctrl F is used to return the item.
Thanks in advance.
Tidak ada komentar:
Posting Komentar