Form Question

M

Matt W.

I have a lot of forms that are all identical to each other. If i need to make
a change to the form i have to go into each form and make the change. Is
there a quicker way to change the design of one form that gets applied to all
the forms? Any input is appreciated. Thanks
 
R

Rick B

Why would you have "a lot of forms that are all identical"

The answer is to delete all but one.
 
M

Matt W.

The designs are identical, each form gets different information from
different queries
 
R

Rick Brandt

Matt said:
The designs are identical, each form gets different information from
different queries
Click to expand...

The RecordSource of a form can be changed easily in code. You can do all of
this with one form.
 
P

Peter Danes

Make one form and set its recordsource at runtime.

Me.RecordSource = "NameOfQuery"

--
Pete

This e-mail address is fake to keep spammers and their auto-harvesters out
of my hair. If you need to get in touch personally, I am 'pdanes' and I use
Yahoo mail. But please use the newsgroups whenever possible, so that all may
benefit from the exchange of ideas.
 
M

Matt W.

Well, Different users will be using this Db and I don't want them to have to
change the record source every time they need to look at other data. I was
just wondering if there was an easier way, Thanks
 
J

John Vinson

Well, Different users will be using this Db and I don't want them to have to
change the record source every time they need to look at other data. I was
just wondering if there was an easier way, Thanks
Click to expand...

How do the queries differ? Does each query have the same tables, and
the same fields, just different criteria? If so, you only need ONE
form and ONE query; just make it a Parameter query which either
prompts for the criteria, or reads them from a Form. Post back if
that's what you're trying to do.

John W. Vinson[MVP]
 
R

Rick Brandt

Matt said:
Well, Different users will be using this Db and I don't want them to
have to change the record source every time they need to look at
other data. I was just wondering if there was an easier way, Thanks
Click to expand...

I would place a ComboBox or similar in the Form header and based on the entry in
that switch to the appropriate RecordSource. The user wouldn;t even be aware of
what was going on.
 
Top