LincolnMarkV
Programmer
Happy New Year!!!
I have built a scheduling database that is used for workshops. Everytime a new workshop is scheduled, the BeforeUpdate event checks for conflicts in the existing schedule. It does this by using a Dcount versus a query that pulls from the existing schedule. If there is a conflict, a message box is displayed. I want to be able to list the class information in the message box so they know which workshop is conflicting. The query used to check lists all of the information I need.
How can I capture the data from the query that is being run so I can use the fields in the message box?
Thanks,
David
I have built a scheduling database that is used for workshops. Everytime a new workshop is scheduled, the BeforeUpdate event checks for conflicts in the existing schedule. It does this by using a Dcount versus a query that pulls from the existing schedule. If there is a conflict, a message box is displayed. I want to be able to list the class information in the message box so they know which workshop is conflicting. The query used to check lists all of the information I need.
How can I capture the data from the query that is being run so I can use the fields in the message box?
Thanks,
David