Previous Thread

6/30/2006 4:01:02 AM    Same Form Different Query
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...



6/30/2006 6:10:10 AM    Re: Same Form Different Query
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

6/30/2006 7:14:48 PM    Re: Same Form Different Query
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. 
 
-- 
 
Allen Browne - Microsoft MVP.  Perth, Western Australia. 
 
Tips for Access users - http://allenbrowne.com/tips.html 
 
Reply to group, rather than allenbrowne at mvps dot org. 
 
"Joe Leon" <JoeLeon@discussions.microsoft.com> wrote in message 
 
news:BE1DC65F-5729-40EA-A8C6-87C8A3719302@microsoft.com...