drop down form with subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello;

I have a form and a subform. The form is a list of all clients, the subform
contains invoices associated with each clinet.
Currently I have the navigation buttons to flip through every client until I
find the right one and then I can look at their invoices, which is time
consuming.

I would like to make a combo box so that I can pick the client from the drop
down list and then the subform would update with the client invoices. What
is the best way to do this?

Thanks in advance for your help.

G Riff
 
Griff said:
Hello;

I have a form and a subform. The form is a list of all clients, the subform
contains invoices associated with each clinet.
Currently I have the navigation buttons to flip through every client until I
find the right one and then I can look at their invoices, which is time
consuming.

I would like to make a combo box so that I can pick the client from the drop
down list and then the subform would update with the client invoices. What
is the best way to do this?

Thanks in advance for your help.
Click to expand...

I would create a combo box and populate it with ClientName and ClientID
Hide the ClientID and make it the bound column
Create your subform for the invoices using a query that uses ClientID to get
the invoices
Name your Combo box the same as the parameter in the query leaving off the @
symbol in the combo box name and when you select a name in the combo box your
subform will update with the invoices for that client.
 
Thanks Steven;

I can't get this to work. I set up the combo box, but when I try to click
on a client, the computer beeps and I get a "Can't edit this field, is bound
to Autonumber ClientID".

Thanks,
Griff
 
Back
Top