Detail Line objects problem

L

Langton

I've created a subform that is a continuous form that looks like the following:

ComboBoxA (FieldA) - ComboBoxB (FieldB) - ComboBoxC (FieldC)
---------------------------------------------------------------------------
ComboBoxA (FieldA) - ComboBoxB (FieldB) - ComboBoxC (FieldC)
---------------------------------------------------------------------------
Etc.

The ComboBoxA List is populated by a query that is the same for every record.
The ComboBoxB List should be populated based on ComboBoxA value.
The ComboBoxC List should be populated based on ComboBoxB value.

The first record in the subform works as expected.
All subsequent records appear to be taking the values (ComboBoxA and
ComboBoxB) from the first record in the subform, regardless of what record I
am operating on.
In the query for ComboBoxB, the condition is "Like [cmbBoxB]" (similar for
comboC).
What do I need to change the LIKE condition to so that it looks at the
current record rather than the first record on the form?

Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top