Form Template.

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.
 
N

NetworkTrade

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.
 
J

Jason

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.
 
Top