Binding a control on a form to a table

[Joy]

Hi, I am very new to coding in MS Access/ VB Code and I need help binding
controls on a form to a table. Hence, now my controls are unbound. I've been
trying from the property of the control- ControlSource so that when I hit the
drop down arrow I get fields to bind it too. When I click on the ... it takes
me to the expression builder, but not sure what type of expression to do
here. Pls help as I am reading the Help files, but sadly not making sense for
me. Thx Joy

 

[Jeanette Cunningham]

Joy,
to bind the form, build and save a query from the table or tables that are
needed to cover all the fields you want on your form.
In design view of the form, on the properties dialog, on the data tab,
--click the drop arrow on the text box next to Control Source
--choose the query you created above
--if your query includes all the fields you need for your form, you will be
able to bind each control.

Jeanette Cunningham