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
 

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,304
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
76,304
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.
 

Forum statistics

Threads
1,141,912
Messages
5,709,287
Members
421,625
Latest member
Natalie1107

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top