combo box to list box then to a specific form

[Guest]

Hi,
When I select a value from a combo box to open a list for that value then
double click any list result to open a specific form, why is it that it ask
me to enter a parameter again? Let say I select UK from the combo, all the
product of UK displays in a list which the column key is the product#, when I
double click one of it, a form (w/c identifies by product#) of that specific
product# should open but it asks me to enter the product# again.

Please help...

Thanks,

 

[Rick Brandt]

Hi,
When I select a value from a combo box to open a list for that value then
double click any list result to open a specific form, why is it that it ask
me to enter a parameter again? Let say I select UK from the combo, all the
product of UK displays in a list which the column key is the product#, when I
double click one of it, a form (w/c identifies by product#) of that specific
product# should open but it asks me to enter the product# again.

Please help...

What is the code in your double-click event?

What is the RecordSource of the form being opened?

Does this form ask for a parameter when opened from the db window or only when
opened by your code?

 

[Guest]

The last form can be opened w/o entering a parameter, the record source is
direct from the table. The combo box and the list form are from a query.
The double-click code: stLinkcriteria " [Product#] = " & Me![List0].Value