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

Signature
Thanks in advance
Stefan
jl5000 - 31 May 2005 03:27 GMT
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

Signature
jl5000
<a href="http://www.joshdev.com"></a>
> I have a form which I use to invoice clients. This is actually 1 form with 2
> subforms
[quoted text clipped - 13 lines]
>
>