Can I use a lookup table on a subform to enter data on a main form

[Guest]

I have a main form where I would lke to enter data into a table using
information from a lookup table on a subform. I use a control button to jump
to the subform and another to get back to the main form. How can I link the
selection on the lookup subform to be entered into the field on the main form?

 

[Joan Wild]

I can't imagine a scenario that would require a value in a subform to be
stored in the underlying table of the main form.

Could you describe the tables and relationships?

 

[Guest]

I am a novice and apparently there are a few cards missing from my deck.
I have 2 fields on my main form. Somewhere I got the impression I could use
2 subforms to provide lookup functions to use to select the data for each
field on the mainform. The contents of each lookup table (on subforms) have a
fixed number of possible choices spelled correctly one time to eliminate
typos and keystrokes. If there is an easier way I'm interested. I also have a
3rd subform for inputing data that relate to the 2 fields on the main form
all of which represent a single record.

 

[John Spencer]

Instead of using subforms, why don't you use comboboxes? This sounds like
what they are designed to do, especially if you are only displaying/using a
single column.

The row source of the comboboxes would be the row source you are currently
using in the subforms. The comboboxes Control Source would be the same as
the control source of the mainform's current controls.

 

[Joan Wild]

You should just use comboboxes to provide the lookup function to your
tables.

You can use the combobox wizard and it will guide you through the steps of
creating the comboboxes on your main form.