Combo in subform

[JB]

Hi all
I have a main form, frmClient, that has a couple of subforms in it.
One subform is where the user can add the Contact details, name, phone etc,
showing one record at a time with it's own navigation buttons to go to next
or previous contacts and able to add as many contacts for each client (in
the main form) as you wish.
I've got a control to enter the date for a 'follow up' call. I want the
user to choose just one contact for that follow up. And I'd like it to be
visible when going into each Client. (because when going to each client, the
subform always shows the first contact)
So what I've done so far with a query is a new subform with the Follow-up
control and a combo box for the contacts. In my query I have the ClientID,
ContactId, ContactName & Followup.

In the client form, the first data showing in the combo box is a contact
belonging to the client whose record you're in, great, BUT when you click
the down arrow to choose another contact, it shows ALL the contacts of all
the clients.
How can I restrict it to make visible only the contacts for that particular
client?
I hope that makes sense
Thank you

 

[Ken Snell \(MVP\)]

Please provide more speciific details about the form/subform setup. It's not
clear from your description whether the combobox of contacts that you want
to filter is on the main form or in one of the subforms. And give names of
the controls that hold the information -- that'll be important to help you
change the design of the form the way you wish.

 

[JB]

thank you for your reply. I think I was being a bit ambitious and making it
too complicated. I did find a better way of doing it.
Thanks for your time.
Jen