Form Template.

  • Thread starter Thread starter Achase
  • Start date Start date
A

Achase

I can't seem to find the answer in the forum or in Access help so posting the
question. I have created a form based on a query in access. I want to use
the Layout over with different query criteria. The fields showing all remain
the same just the results will be different based on the query executed. Is
there a way to accomplish this? I could do it if there is a way to change
the dependencies or if there is a way to use the layout and just link to
different queries.
 
yes, just right click on the form object - and select copy

then right click in the Database window and select paste - and give it a new
name

then open this new form in design view - go to its properties window , and
change the record source property to the query you wish to use.
 
If using the same table then the recordset can be changed or use the forms
filtering - no need for extra forms when the layout and table are the same.
 
Back
Top