Combo lookup on subform

[Jacqueline]

I would like to build a combo box that looks up records based on the subform.
The subform is in datasheet view so the combo must reside on the main form,
is there a way to do this?

 

[Maurice]

You could use the combobox wizard and use the subform's recordset as a source
for your combo. In the after update i guess the code could look for the main
forms record. But i do have to say that it sure sounds backwards that way.
Normally it is done the opposite way. Could you explain a little why you want
it that way..

hth

 

[Jacqueline]

Thanks, for the input. I figured out that I was going about it backward. I
solved the issue by creating a popup form that gives te user what they need.