G
Guest
I have a form with a record source of qClients which is a query of the client
table. I want to be able to have a Combo Box on the form so that when the
user selects the Cleint using the combo box then the other fields associated
with that clientid will update on the form and the Navigation record
indicator will also update to show which record is currently selected.
Currently when I try to make the clientid on the form a combo box and use it
and have all the other fields follow they dont. And the Navigation record
indicator does not follow and after I have used the combo box to select a
clientid then the Navigation buttons freeze.
How can I make it so the form is based on a query and be able to either use
the Naviation Buttons to select the next record and/or use the combo box to
select by the clientid and have the form update itself properly.
Thanks for your help.
table. I want to be able to have a Combo Box on the form so that when the
user selects the Cleint using the combo box then the other fields associated
with that clientid will update on the form and the Navigation record
indicator will also update to show which record is currently selected.
Currently when I try to make the clientid on the form a combo box and use it
and have all the other fields follow they dont. And the Navigation record
indicator does not follow and after I have used the combo box to select a
clientid then the Navigation buttons freeze.
How can I make it so the form is based on a query and be able to either use
the Naviation Buttons to select the next record and/or use the combo box to
select by the clientid and have the form update itself properly.
Thanks for your help.