macro to open a form by searching the subform

[nickthompson1988]

Hey,

I have two tables which make up a form and subform.

tblPatient Details and tblMDT Meeting.

The form is the frmpatient details and the subform frmmeeting details.

Basically i have a button to search by meeting date which i hoped would open the form and show the patients discussed on a certain date.

I did a query which prompts a user to enter a date and a macro to open frmPatient details and included the query in the macro, but when i click on the button it brings up tblMeetingDate.Meeting Date and when you click ok it brings up the prompt to enter a meeting date.

Is it actually possible to open a form by searching for a field in the subform? if not what can i do?

Thanks

 

[wiremonkey22]

Not sure i quite sure i understand what ur trying to do here couldnt you just make a form built off your prameter query to show patients seen on a certain day.