niall_duggan96
New member
- Local time
- Today, 03:28
- Joined
- Jan 27, 2016
- Messages
- 2
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
FROM tbl_appointment
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.
Any help would be great.
On my database i have prevented double booking by using queries.
SELECT tbl_appointment.StartTime, tbl_appointment.EndTime
FROM tbl_appointment
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.
Any help would be great.