Cascading combobox inside a subform error

mel9338

New member
Local time
Yesterday, 21:27
Joined
Aug 18, 2004
Messages
6
hello everyone reading this thread... i didn't mean to start a thread that have been flooding around this forum.. i been trying to solve the error for hours ..searching around this forum seems to get me no way...

i basically try to make a form where there is a sub form contain a cascading combo box.. at first i use a simple form and the cascading combo box work perfectly..but when i try to put it into a sub form.. i got error "Enter Parameter Value".. can anyone have a look at my database and tell me what problem i encounter? advance thanks for wasting your time lookin at my pretty simple database
 

Attachments

Change

[FORMS]![frmInvoiceDetail]![Cat]

to

Forms![tblInvoice]![frmInvoiceDetail].Form![Cat]

in your query powering the Product Combo

You have to reference Subform controls in a more explicit way as shown above. If you are not sure of the syntax, use the expression builder.
 
Thanks Alot

oh..i see where the problem lies now.. great...thanks for the help Fizzio...:)
 

Users who are viewing this thread

Back
Top Bottom