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.
--
Jacqueline
"Maurice" wrote:
[Quoted Text] > 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
> --
> Maurice Ausum
>
>
> "Jacqueline" wrote:
>
> > 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?
> > --
> > Jacqueline
|