How to bind controls to a table at design time?

[amorts]

Hi all,

What is the easiest way to point various access controls to a specific underlying table, (without using a wizard).

I have built up my form but all the controls are unbound.

Please help.

Thanks,
Adam

 

[Norie]

Adam

The easiest way is to, before you start adding controls, set the Record Source for the form.

Then you can get a list of the fields by going to View>Field List.

You can then just drag and drop fields onto the form.

Access will automatically create bound controls, and labels for the controls.

The type of control will normally be a textbox but if you had any lookup fields a combobox would probably be created.

 

[amorts]

Thanks. So I take it there is no retrospective way to bind my controls?

How to I specify the record source? Again, without using the wizard

 

[Norie]

Just set it in the Properties sheet of the form.

There should be a dropdown list of tables and queries for the Record Source property.

And there's also the ellipsis ... which will allow you to build a query.

Oh, and you can bind controls retrospectively - just set their Control Source property.

 

[amorts]

Thanks for your help! All sorted.