Controls, Queries, Tables, and Forms

The last time I created a database was using Filemaker Pro 6 years ago and haven't done anything since.

I have opened up MS Access to build another one.

I find I have some conceptual hurdles to jump to get on with the job.

Am I right in understanding that a table is where record level data is stored. That is, a form can have "field like box" on it that can have data entered into it, that can be filled with the result of a calculation, but that if it is not linked to a table field [and is that bound and unbound?] it will not remain when the form is closed.

This raises another question - if I switch from one record to another in a form, and some of the data is from a table, and some is calculated "unbound" ? if I then tab back to that record [? is a record in a form called a from record and in a table called a table record ?] in the form will the unbound data still be visible in the form?

Can a query refer to that unbound data in that form?

Does a query create a kind of query level table that can exists only until the query is re-run? File closed?

Thanks.

A1. Yes table is like a dbf in foxpro or dbase wherenin you can store multiple records. When a form's recordsource (Form Tab Selecttheform designmode and get property box from clicking on left top corner. If the recordsource property is filled with tablename or queryname then it is abound form otherwise unbound form. You can store calculated field also to a resulttextbox which is bound to the table by writing somecode at the time of calculating.
like
me!resulttextbox = me!txt1+me!txt2
In unbound form also you can do that by writing vbcode in the click event of a command button

Try with some sample northwind database for the possibilities.

What you can do in other databases you can do it in MsAccess also (except triggers) in a much easier way.

Can a query refer to that unbound data in that form?
No. For unbound forms use code inside the form to fill the textboxes.

Does a query create a kind of query level table that can exists only until the query is re-run? File closed?

Query can be saved with some name and later can be called
within forms as docmd.openquery queryname or you can directly execute from querytab.



Thanks.[/QUOTE]