Prompting for record 1

[mclellan]

Hello,

I have a form bound to my invoice table, and I created an unbound combo box based on my customers.

In the AfterUpdate event, I added the code:
Private Sub Combo11_AfterUpdate()

Me.Filter = "tblInvoices.InvoiceID In(SELECT tblInvoices.InvoiceID FROM tblInvoices WHERE tblInvoices.InvoiceID = Me!Combo11)"
Me.FilterOn = True

End Sub

For some reason, every time I change my combo dropdown, I get asked for the parameter value Me!Combo11.

Not sure what I am missing!

Thanks for your help
Barry

 

[PHV]

What about simply this ?
Me.Filter = "tblInvoices.InvoiceID = " & Me!Combo11

I assumed that InvoiceID is defined as numeric in tblInvoices.


Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[mclellan]

Thanks that fixed the prompting!!


Have a great day
mclellan