Filtering to Cline

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

Guest

I have a form which I use to invoice clients. This is actually 1 form with 2
subforms
Client - Invoice# - Charge Detail

I Have a combo box to choose the client on the client form.

I have a combo box to choose the invoice# on the invoice. I am trying to
filter the invoice's to only show the invoices for the current client shown.

I have a query for the combo box where the client field is filtered to the
current client. This seems to work for filtering the invoices to only that
client the first time I use it, but if I change the client the invoice
remains filtering to the first client that was chosen.

I tried to do a save command on the client field but that hasn't worked
 
Use the after update event where you select the client, like

Private Sub Client_Id_AfterUpdate()
me.Mysubform1.requery
me.Mysubform1.requery
End Sub

But I will recommend you use the master and child link fields instead, read
the help file for detailed information
 
Back
Top