Add Field to Query through Code?

  • Thread starter Thread starter Gibson
  • Start date Start date
G

Gibson

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?
 
Open the querydef object and update the SQL property. See the help file for
a general example.

--
Steve Clark, Access MVP
FMS, Inc.
Call us for all of your Access Development Needs!
1-888-220-6234
(e-mail address removed)
www.fmsinc.com/consulting
 
Back
Top