Hi Xero,
Bind the form to your table, or to a query that is based on your table. A
bound form is one that includes a recordset. Open your form in design view.
Click on View > Properties to open the properties dialog, if it is not
already displayed. Make sure that the word "Form" is displayed in the blue
title bar of the properties dialog (you can click on the small black square
in the upper left corner to select the form). Then click on the data tab. The
Record Source property should be set to the name of your table, or to a query
that is based on this table (or to a SQL SELECT statement, but you can
concern yourself with that at a later point in time).
Click on View > Field List. If the form is correctly bound, you should see
the name of the fields in the field list. Click on a textbox on your form.
The name of the textbox should be shown in the blue title bar of the
properties dialog. You should now notice that there is a Control Source
property on the data tab. This needs to be set to one of the fields that is
shown in the field list.
Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________
:
hi.
i have created a Table (Stduent Info) and a Form (Info Overview). In both of
the forms there are two fields: Student Name.
i want to set up the database so that when i input a name into the Table,
the name will appear in the Form automatically, and vice versa.
how do i do this? thanks.
