If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
Can I use a lookup table on a subform to enter data on a 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? |
#3
|
|||
|
|||
Can I use a lookup table on a subform to enter data on a main
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? |
#4
|
|||
|
|||
Can I use a lookup table on a subform to enter data on a main
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? |
#5
|
|||
|
|||
Can I use a lookup table on a subform to enter data on a main
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? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Customers- Contracts form problem | GL | Using Forms | 10 | February 7th, 2006 04:05 PM |
Query is not updatable - | Doug Johnson via AccessMonster.com | Running & Setting Up Queries | 3 | January 21st, 2006 12:36 AM |
Multiple Options Group | Patty Stoddard | Using Forms | 19 | August 4th, 2005 02:30 PM |
Design help, please | SillySally | Using Forms | 27 | March 6th, 2005 04:11 AM |
Recordset in subform based on field in parent form | Lyn | General Discussion | 15 | June 14th, 2004 03:10 PM |