Combo lookup on subform


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?
 
Ad

Advertisements

M

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
 
Ad

Advertisements

J

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.
 

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