Form Data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two tables and I have a form that pulls information from one table and
I copied the form and remaned it diffrent and I want it to pull data from the
other table, but when I click on Field List it only shows the list for the
one table. How can I make that form pull data from the other table. Thanks,
Anthony
 
Anthony

Open the (new) form in design view. Go to Properties for the form. Change
the source from your table1 to your table2.

As an alternate approach, rather than pointing directly at the tables,
consider creating queries (one per table), and pointing your form(s) at the
query(s).

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
 
No, how do I change the table name when I went and pick the table name and
what value it comes up with a #Name?.
 

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

Update Two Tables Using One Form Contents 0
This seems like an easy lookup...what am I missing? 4
Separate Form 0
Using an append query in a subform 1
How to pull a record to a form and saving it to another table. 6
Forms: not working right with tables. 4
VBA - retrieve data on last create named range from previous inserted named range 0
Form/subform 1

Back
Top