Change table or query in a form?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

fox - 28 Jun 2006 19:59 GMT

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

Reply to this Message

Steve Schapel - 28 Jun 2006 20:34 GMT

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.

Signature

Steve Schapel, Microsoft Access MVP

> Hi!
> I have a question about form's table/query. Now I have a form, however,
[quoted text clipped - 4 lines]
>
> fox

Reply to this Message

fox - 28 Jun 2006 21:25 GMT

Got it, thank you.

fox

> Fox,
>
[quoted text clipped - 12 lines]
> >
> > fox

Reply to this Message