How to refer to parameters in navigation forms in a query?
I'm having a problem with my database where a form is working perfectly okay but when I open it as a Subform in a navigation form I get errors.
On my database i have prevented double booking by using queries.
SELECT tbl_appointment.StartTime, tbl_appointment.EndTime
WHERE (((tbl_appointment.ApptDate)=[Forms]![frm_appointment_new]![ApptDate]) AND ((tbl_appointment.StylistID)=[Forms]![frm_appointment_new]![StylistID]));
This is the SQL of my query.
The problem is when ever I click on my combobox start_time on my navigation form it comes up.
Enter Parameter value Forms!frm_appointment_new!apptdate
My navigation form is a 2 way navigation form with one button named appointments and the other named book.
Re: How to refer to parameters in navigation forms in a query?
If you really have time (like me) just make the navigation menu on each form (functions behind the buttons are of course public subs in a module). Worked for me. I also made sure that there was only one form open at any time. (you can get bugs if you don't... nobody wants bugs)