View Single Post
  #7  
Old January 13th, 2009, 03:08 AM posted to microsoft.public.access.forms
strive4peace
external usenet poster
 
Posts: 1,670
Default Data entry into table field.

that means you used an equation as the Controlsource -- not the name of
a field. In the controlsource property, make a choice from the list
(note the arrow on the right when you click in that property)

Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
(: have an awesome day
*




FBrnstrmr wrote:
after adding the controlsource I cannot choose antry from the combobox it says
"can't be edited it is bound to the expression ....etc."

"strive4peace" wrote:


the ControlSource is the field name (from the form RecordSource) that
the combo is bound to

"How do I link the form data to the table once it is made"

put the table name in the form RecordSource

to create a new record, click the [*] button in the lower left corner
of the screen where the navigation buttons are

Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
(: have an awesome day
*




FBrnstrmr wrote:
How does the data chosen from a drop-down list or combo box get entered into
the table field? How is it linked to the record as opposed to (or in addition
to) the combo-box? I appear to have worked in reverse in that I created a
Form to enter data from a combo-box, but don't yet have the place to store
the chosen data. How do I link the form data to the table once it is made,
please? Since the data will be new how does it create a new record for that
data?
Thanks in advance for any help you may provide.
-F