Forms to New Table/Queries

S

shanearmstrong

I have created a form that I am very happy with now the bad thing is I used a
Table so it is not sorted etc.

I now created a querie and wanted to take that form that is linked to a table
and change all the fields to the new querie. Can this be done easy or should
I re-create the form from scratch again because it has over 200 objects on it.


Thanks in advance
 
A

Allen Browne

Open the form in design view.

Open the Properties box (View menu.)

On the Data tab, set the Record Source property to the name of your query.

(If you don't see that property, you are looking at the properties of a text
box instead of the properties of the form.)
 
Top