How to bind controls to a table at design time?

amorts

Board Regular
Joined
Jan 4, 2006
Messages
181
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
 

Some videos you may like

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
75,918
Office Version
  1. 365
Platform
  1. Windows
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

Board Regular
Joined
Jan 4, 2006
Messages
181
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

Well-known Member
Joined
Apr 28, 2004
Messages
75,918
Office Version
  1. 365
Platform
  1. Windows
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,114,051
Messages
5,545,724
Members
410,702
Latest member
clizama18
Top