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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

linronamy - 08 Feb 2006 16:22 GMT

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?

Reply to this Message

Joan Wild - 08 Feb 2006 17:34 GMT

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?

Signature

Joan Wild
Microsoft Access MVP

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

Reply to this Message

linronamy - 09 Feb 2006 01:21 GMT

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.

> 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.
[quoted text clipped - 6 lines]
> > can I link the selection on the lookup subform to be entered into the
> > field on the main form?

Reply to this Message

John Spencer - 09 Feb 2006 13:15 GMT

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.

>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
[quoted text clipped - 18 lines]
>> > can I link the selection on the lookup subform to be entered into the
>> > field on the main form?

Reply to this Message

Joan Wild - 09 Feb 2006 14:40 GMT

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.

Signature

Joan Wild
Microsoft Access MVP

> I am a novice and apparently there are a few cards missing from my
> deck.
[quoted text clipped - 21 lines]
>>> form. How can I link the selection on the lookup subform to be
>>> entered into the field on the main form?

Reply to this Message