subform combo box

[char]

Hi,

I posted a few days regarding using a combo box to select a certain record on a web based database.

I did this using the macro:

SetFilter=[Forms]![Formname]![cbobject]
Requery

This worked perfectly. I then want to add this form to another as a subform.

So my main form would be [Test details]... Test ID, Test Date, Test Attachment
Subform would be [test results] with fields... Test ID (autovalue from main form) Weld ID (selected from combo box on this subform) and Pass/Fail result which the user would self type.



When I used the combo box on the form before I pull it accross into [Test Details] It works perfectly. But when it is a subform the error message reads:

You either have an error in your expression or you have attempted to use an undeclared parameter. Check the expression for errors or enter the parameter '[Weld_ID]' in the Query dialog.

Then a query box pops up asking me to enter weld ID.. not sure why this is happening could anyone help?

Thanks

[rpeare]

is the filter you're applying going against the WELD_ID field?

if so you may need to modify the query running the form to add a parameter value (even though your query may show it in some instances you have to, for lack of a better word, 'declare' a field as a parameter).