Update Query through Code?

[EddyLLC]

I have a backend mdb and a frontend mdb. I have added a field to a table in
the backend using code. Now I need to update a query in the front end that
feeds a form to include the new field added to the table in the backend.
Can this be done through code thus the adding of the field and updating of
the query is done in at the same time as it were?

 

[mp9]

I'm pretty sure you can modify your query using SQL, specifically the ALTER statement.

You can then embed the running of your ALTER SQL statement within your code.

http://www22.brinkster.com/accessory/