Question How to refer to parameters in navigation forms in a query? (1 Viewer)

niall_duggan96

New member
Local time
Today, 19:20
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.
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 03:20
Joined
May 7, 2009
Messages
19,169
you will have a hard time figuring this out, navigation form is really navigation pain.
 

Grumm

Registered User.
Local time
Today, 20:20
Joined
Oct 9, 2015
Messages
395
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)
 

sneuberg

AWF VIP
Local time
Today, 12:20
Joined
Oct 17, 2014
Messages
3,506
That looks about right if the names are correct. Are you sure about [frm_navigation]. I thought Access named it [Navigation Form]?
 

Users who are viewing this thread

Top Bottom