Accessing more than one Table from a MS Access Form

  • Thread starter Thread starter Roshan Abbasi via AccessMonster.com
  • Start date Start date
R

Roshan Abbasi via AccessMonster.com

While working with a table-bound form, how to access additional table(s) for
data comparison or even updating them.
 
Base your form on a query and include all the tables you need.

If you open the form in design-view and go to the properties tab, you can
build the query right there and not have to save it separately in your
database.
 
It is a brillian idea of using multi-table Qyery.

Is it also possible to open an ADODB.Recordset of a table and have better
control on manipulating the data? I tried to do it, but the ADODB.Connection
comes into my way as it needs open the "Data Source", which is already in use.


Any help on a way for creating Recordset, with anticipated thanks.
 
Back
Top