Importing data from Tables into Forms

P

Pourchet

I have imported data from Excel into Access 2007 and have been successful. I
know notice that this information goes into Tables. I am unable to import
that information into Forms. How do I populate Forms with this imported data?

Has anyone got any ideas as I am getting quite stuck in this area. Thanks
in anticpation of some help.
 
J

Jerry Whittle

The record source for a from must be a table or query. In other words the
form must be pointed at a particular table. If you are trying to use one form
for numerous tables, that will be difficult. You will need to change the
record source which can be done through code, but difficult.

Are you importing the Excel data into just one table at is the record source
of a form? That would be best.
 

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

Adding data to MS Access from csv file 0
Linking data in MS Word into Excel 5
Copy previous record into form field 0
Import into multiple related tables? 1
Appending an existing table with imported Excel data 0
Access 2013: Form problem in reading data tables; relationship one-to-one 0
Importing XML Data in Access 2003 1
Importing import specs 0

Top