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

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?

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?


--
Joan Wild
Microsoft Access MVP

linronamy wrote:
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?

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.

"Joan Wild" wrote:

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?


--
Joan Wild
Microsoft Access MVP

linronamy wrote:
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?

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.


"linronamy" wrote in message
...
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.

"Joan Wild" wrote:

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?


--
Joan Wild
Microsoft Access MVP

linronamy wrote:
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?

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.

--
Joan Wild
Microsoft Access MVP

linronamy wrote:
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.

"Joan Wild" wrote:

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?


--
Joan Wild
Microsoft Access MVP

linronamy wrote:
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?