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

Problem importing data into linked table 2
Import into multiple related tables? 1
Importing XML Data in Access 2003 1
using table stucture and importing data 1
Importing Excel Data into MS Access Table 1
Importing text into number field- Error 4
Importing Project 2007 XML data into Access 2007 0
Importing excel into access 2

Top