Control's ControlSource

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a control on a form and choose not to use
the wizard to link this control's control source at that
point. Now I need to link this control to a field in a
table. How do I do this.
Thanks
Reggie
 
I have created a control on a form and choose not to use
the wizard to link this control's control source at that
point. Now I need to link this control to a field in a
table. How do I do this.
Click to expand...

The answer is in your subject line. You go to the property sheet and find
the ControlSource property for the control. Enter the name of the field in
that property. There will even be a drop-list of choices showing your field
names.
 
I have tried but there was no drop down list on the
controlSource. If I type in the field How will the
controlSource know which table this belongs to.
Thanx
 
I have tried but there was no drop down list on the
controlSource. If I type in the field How will the
controlSource know which table this belongs to.
Thanx
Click to expand...

First off, the form must be bound by having an entry in its RecordSource
property. Then the fields from that RecordSource will be shown in the
drop-list for the ControlSource property for the controls on the form. You
cannot have a bound control without first having a bound form.
 
Back
Top