Change table or query in a form?

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

Guest

Hi!
I have a question about form's table/query. Now I have a form, however,
it's data come form a exiting table/query. Now I make a new query, can I
change its link to the new query? Or I have to remode the form?

Thank you.

fox
 
Fox,

The data accessed by a form is determined by the form's Record Source
property. If you open the form in design view, open the Property Sheet,
you will be able to change the Record Source property to the name of
your new query. Assuming the new query has the same field names as the
old query, it should work fine straight away.
 
Got it, thank you.

fox

Steve Schapel said:
Fox,

The data accessed by a form is determined by the form's Record Source
property. If you open the form in design view, open the Property Sheet,
you will be able to change the Record Source property to the name of
your new query. Assuming the new query has the same field names as the
old query, it should work fine straight away.
Click to expand...
 
Back
Top