forms using queries

[ajaymansata]

Hi all
I am creating a form using form wizard which used a query as its source.What i want to ask is that can i make changes to the form and will it be reflected in the tables which is used to build up the query

 

[E-D]

changing a form will not reflect on the source tables or query

 

[Fizzio]

When you say change the form I'm assuming you mean the data displayed. If so, the form is based on a query which provides a dynamic view of the table. Therefore any changes you make in the form will be automatically updated in the table (when you save that record eg moving to new record etc.)
Any aesthetic changes you make to the form ie moving around the controls on the form will have no effect on the data it displays.

 

[GTrice]

While using queries works, it is a whole lot easier to debug later if you convert the query to SQL (From the query designer) and paste it in your data source. This works for all but the most complex queries.

Remember to limit the data to only what you need and to name your queries properly e.g. starting with "que" - queAnimalData

Cheers