Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Using independant table in query 1

Status
Not open for further replies.

xezekielx

IS-IT--Management
Jun 30, 2005
93
CA
Hi! I have a table called tParameters that contains the parameters of the system. It contains only 1 record and the data can be modified with a form. Now I need to use the content of this table in a query to update other tables with a form. The query works and outputs the desired results but the problem is that no data can be modified. If I remove the table tParameters from the query, everything works and I can modify the data in the other tables used in the query. Any idea what I could do? Thanks a lot!
 
Hi

Remove the paramter table from the query

In the on open event of the form, read the row from the table as a recordset

extract the columns you want and use then to update teh other tables

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now - UK
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top