Combo in subform

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

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.

--

Ken Snell
MS ACCESS MVP
http://www.accessmvp.com/KDSnell/


"JB" somehow@somewhere wrote in message
...
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

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

"Ken Snell (MVP)" wrote in message
...
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.

--

Ken Snell
MS ACCESS MVP
http://www.accessmvp.com/KDSnell/


"JB" somehow@somewhere wrote in message
...
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