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

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