Please Help

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

Guest

To all the wise ones,
I have just started understanding access and VB. As an
exercise, I want to be able to access the fields of a
table created in my database. I have created a form with
controls but these controls are linked to other tables.
How can I create a procedure (in VB or access tools) in
my forms code sheet to reference and use this table.
Your input will be appreciated.
Jen
 
Thanks for the advice.
Can the table be used/accessed directly without the use
of a query.
-----Original Message-----
Create a query that joins the various tables the way you want, and use that
query as the recordsource for your form.

Note that queries that join tables together sometimes are not updatable.

Check
http://msdn.microsoft.com/archive/en-
Click to expand...
us/dnaraccess/html/msdn_harness.asp for
 
You can access tables directly but you are more restricted in what you can
display on a single form. Queries give more flexibility.


John
 
Hi Jenna,

If you want to access this table from your code, independently of the
query or table to which the form itself is bound,

1) You can use functions like DLookup() to get single values from the
table

2) You can open a recordset on the table (in real life it would more
often be on a query on the table) and then use VBA code to manipulate
the records and fields in the recordset.
 
Back
Top