Question re:Imported Excel into Access 2007 - data retrieval

  • Thread starter Thread starter Lucy
  • Start date Start date
L

Lucy

I'm hoping someone can help. New to access 2007, building as I learn. I
have imported an excel spreadsheet already complete with data. Each record
consists of a Store Name Address Photo number etc. I created a new table
called Service with numerous fields, but have created a "lookup" list for the
store number from the original imported file. Question is what do I have to
do to have the information of that store number automatically drop into that
service form? Thank you.
 
If your form properly currently populates with a record when you first
open it and you can then step through your records and it populates
with the correct data each time then the following will serve to get
you going. If the above isn't true then the solution won't work
either.

With your form in Design view, create some space in the Heeder section
sufficient for a new control. With the Wizard enabled, select the
Combobox icon and then draw a new combobox control in that new space
in your form header. When the wizard gives you choices on what you
want to do, select "go to a specific record". Finish stepping through
the wizard (name it something like cboFindRecord) and test it.

HTH
 
Back
Top