Using a list box to populate a subform

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jerry Anderson - 29 Apr 2008 18:15 GMT

In Access 2003, I have a form with no control source; only a listbox
populated from a query. I also have a subform that I want populated from a
value in the listbox. Since there is no control source for the form, the
wizard that establishes the relationship between the two forms shows empty
for the main form. I tried establishing the relationship with a text box that
gets its value from the list box on the main. However, when I go into form
view, there is nothing in the subform.
Any ideas?

Reply to this Message

John W. Vinson - 30 Apr 2008 00:21 GMT

>In Access 2003, I have a form with no control source; only a listbox
>populated from a query. I also have a subform that I want populated from a
[quoted text clipped - 4 lines]
>view, there is nothing in the subform.
>Any ideas?

What is the Recordsource of the subform? You may be able to make it work by
typing the name of the listbox into the Master Link Field property of the
subform; that's not an option that the wizard will offer you, but it does
work.

Signature

John W. Vinson [MVP]

Reply to this Message