Same Form Different Query

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

Guest

I would like to take the Form I already have created that writes data to a
table based on a query copy the form and change a property in it so that now
I can use a different query with it. Now I end up with two forms to place in
my switchboard.
How do I change the property in the form copied to point to the second query?

Thanks... Joe...
 
Open the 2nd form in design view.
On the Data tab of the Properties box, set Record Source.

If you don't see Record Source, you are looking at the properties of a text
box instead of the form.
 
If there is a subform on the form, you may have to create a copy of it.
If you don't and you make any changes to that subform under the second
"form" those changes will also appear on that subform when it appears
under the first "form".

If you do copy a form that has a sub form then you have simply created
two main forms that are showing THE SAME subform.

Ron
 
I opened the 2nd form in design view but the only Data tab I see is for the
list boxes in the form. I am not able to see a Data tab for the form. I
clicked in the body of the form while in design view and the Data tab is
blank. It does not show anything where I can set the Record Source. Please
help... thanks! Joe....
 
Finally found it... I was clicking on the inside of the form instead of the
top bar.

Thanks! Joe..
 
Back
Top