Forms to New Table/Queries

  • Thread starter Thread starter shanearmstrong
  • Start date Start date
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
 
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.)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using an append query in a subform 1
queries and forms 0
Separate Form 0
Add new records into source table on Form 8
Data entry to table from a form 1
create a form from a report? 1
Add Field from Query to Form - Access 2007 9
Re: Link form to table 2

Back
Top