MS ACCESS 2000

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

Guest

How do I incorperate fields from different tables into a form manually? I
can do it using 'form wizard' but as I am using a lot of fields it is unable
to draw up a draft form. I can also create a form manually, building it one
field at a time but I only seem able to do this using fields from a single
table. This strikes me as a little daft, please help...
 
You need to set the form's record source to a query instead of just a table.
There are two ways to do this...

Create and save a query with the data you need in the form. Then set the
form's record source to this named query.

In the form properties next to the Recour Source field, click the [...]
button to start the query builder. If you already have a table listed, it
will start the query with this table and you can add onto it as need be.

Tony Vrolyk
 
Back
Top