Question re:Imported Excel into Access 2007 - data retrieval

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.
 
L

Larry Daugherty

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access MS Access 2007 Help! 4
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
storing calculated values from forms into a database file 1
Crunch numbers with MS Access: is this possible? 2
Importing Data 5
Access 2007 3
importing data from one table to another 5
Sory Order Problem in Report 1

Top