how to populate a form from one table

[jgclemens]

forgive me if this is obvious - first time working with access. could not find a thread that was this simple of a problem

i have an excel spreadsheet, i have linked an access table to said spreadsheet. the table has columns for deliver to, ship to, address 1, address 2, etc... there is also some additional fields at the bottom of the table the form user will need to fill in (this part i understand how to do)

what i am TRYING to do is populate fields in the form based on the selection the form user. i do not need to save this data entered or selected to a table, it just needs to print.
so do i use a combo box as the initial selection? what do i use (list box?)/ how do i make fields that auto fill with the data from that same row on the table? when they select the "deliver to" from a drop down the rest of the form fills in with the information from that row on the table - ship to, address 1, etc...

PLEASE HELP!!

 

[Klegg72]

Try creating a combo box and use the third option on the first screen of the ComboBox wizard...
"Find a record on my form based on the value I selected in my combo box."

Play around with that

 

[jgclemens]

i don't have a third option. i have two options in the first screen of the combo box wizard 1)i want the combo box to look up the values in the table or query 2) i will type in the values i want.
???

 

[Klegg72]

OK, create your combo box and add the following where condition to the after update event (in a macro or VBA)
="['Field that will define every record in table, like a Primary Key'] = " & Str(Nz([Screen].[ActiveControl],0))

 

[missinglinq]

You don't have the third option because your Form is not Bound to the data. Here's a short tutorial on the subject.

Create a form based on your table or query, including all the fields you want displayed. Then simply:

1. Add a combo box to your form.
   
2. The Combobox Wizard will pop up
   
3. Select "Find a record based on the value I selected in my combobox."
   
4. From the table or query the form is based on, click on the field you're searching by (a field that is unique for each record) to move it to the right side.
   
5. Hit Next.
   
6. Size the column appropriately.
   
7. Hit Next.
   
8. Name the combobox.
   
9. Hit Finish.

Now you can drop the Combobox down and scroll down to the item to search by, or you can start to enter the item, and the Combobox will "autoexpand" as you type. Hit <Enter> and the record will be retrieved.

Linq ;0)>

 

[jgclemens]

it worked - thanks for your help!

 

[inklady]

This works great.. however.. how do you do this.. with 3 separate tables.. ?. that's where I'm having my problem...