Combo lookup on subform

  • Thread starter Thread starter Jacqueline
  • Start date Start date
J

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?
 
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
 
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.
 
Back
Top