Query / Forms ??

[caljohn527]

When I create a table with some fields, and then I save the table and call it customer tables. Now I would like to create a form with several functions and calculations,
My question is, do I go directly to the form and build it. Or Should I Go to query first new, Design View, add the table / field to query. Then go to the form and
Build it.



Can I Get Your thought On This Mater.


John C

[ibgreat]

It really depends on what you want your form to do. If you are just starting to use forms, you will probably want to start with bound forms. These have a direct relation to an underlying table or query (you would have to build the query first). This means that when you change a value on the form it immediately changes the value in the table. The form wizard will do this for you. With an unbound form you have to manually set the recordsource of each object on the form.

HTH