Populating a textbox from a table when the form loads

  • Thread starter Thread starter Tia
  • Start date Start date
T

Tia

How do you populate a textbox from a table when the form
loads?
After clicking the next button, how do you populate the
same textbox with the next record of the same table?
 
Tia,
You need to bind the form to the table and set the
control source of the textbox to the field you want.

The easiest way for you to do this is to use the Access
Form Wizard. Go to the Forms tab in your database window
and click 'New'. Select 'Form Wizard' and select the
table from the list in the drop down box. Click OK. The
wizard takes you through a series of questions then
creates your form based on the table and columns you want
to show.

If you don't want to use the wizard or you already have
the form made you need to open your form in Design View,
select Properties from the View menu. In the properties
dialog, find the Record Source property and select your
table from the drop down list. Once you have selected
your record source, select Field List from the View menu.
The Field List shows you the columns in your table. Click
and drag columns you want to use onto your form.

I hope this answers your question.
..
 
Back
Top