Combo box/subform

[kbreiss]

I've read many discussions that involve selecting a combo box to populate a subform, but nothing has helped me so far. So any suggestions would be great! Here's what I got....2 tables (Appointment,Facility) that are linked by FAC_ID. I have a main form (appointment) that gets it's info. from both tables. I created a subform within that form that queries the following query.....

SELECT DISTINCTROW (Appointment.DL_NUM), Appointment.NAME, Appointment.APPT_DATE AS DTE, Appointment.APPT_TIME AS TME
FROM Appointment
WHERE [FORMS]![Appointment]![Combo22]=APPOINTMENT.FAC_ID;

So in theory I'm visualizing that a user clicks on facility id list box and it populates the subform according to the facility id clicked.

I know I probablly need something that sets that off...like an OnClick...but I have no idea how this works or what I need to do to get it to work.

When I create a combo box the option of "finding a record based on my selection" is not apparent.

Any help would be greatly appreciated since I have been stuck on this for three days. Thanks in advance

Kacy
________
Colorado Dispensaries

 

[glynch]

You can directly link a subform to a master form by filling in the Master and child fields, this should negate the need for having a separate query to try to link them and having to requery the subform on a change of facility id on your main form.

HTH

 

[kbreiss]

Thanks...Works fine.
________
MASTURBATION LESBIAN