Add additional fields to form when using 2+ tables in the wizard

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

Guest

I am using MS Access 2003. I am building a form through the use of the
wizard to combine 2+ table on one form without using child forms. If there
is a way to build it w/o using the wizard I would love it but for now the
wizard works. Once I got the form complete I realized I left a field out.
the only way I could see to add the field is to totally rebuild the form. Is
there anyway around having to rebuild the form to add the additional fields,
as my company will be adding fields every 3-4 months due to the vendor is
adding fields every QTR?
 
Hi Leslie

You should base your form on a query not the tables. Bring each of the
tables into the query and then drag the fields you need on the form on to the
query grid.

If you already have a form made I think it would be a pain to have to
re-make it - no worries. Simply create the query and ensure that each of the
fields on the form has the corresponding field in the query. Save the query
then open the form in design view. Click the forms properties and select the
new query as the source for the form.

To add new fields to the form simply drag them into your new query 1st then
save the query. After this the field will be available on the View –
Available Fields menu on your form

Hope this helps
 
Back
Top