combo box values in Detail section on a form

[qwertyjjj]

I have a detail section with a textbox and a combobox, e.g. laid out like
txt_Name combo_Divisions

The data for txt_Name is populated from a query and as this is a continouous form, there can be any number of textboxes on the form.
I need to populate the combobox based upon the value of txt_Name, which obviously changes with eac record.
Is this possible within the Detail section of a form?

AT the moment, the row source of the combo is set to something like:
SELECT Column1 FROM Table1 WHERE Name = txt_Name;

but this eems to select the same data for every combo box afterwards

 

[boblarson]

I believe you can't do this with continuous forms as it does exactly what you specify is happening. In essence each control is not counted as a separate control in a continous form, just another instance for displaying/editing different data.

 

[qwertyjjj]

Is there anyway way round this at all?
For example, using an expression to list multiple values in the combo box instead?