J
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
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