Can Not Enter Data into Form

[Simon]

Good Evening,

I have a form with a Record Source of a Query and 10 fields that have a
Control Source from this Query. I have an additonal 6 fields on this form
which are Unbound and I would like to enter data into these fields.

When I view this form, the 10 fields are populated as expected, but I can
not enter data into the Unbound fields.

Enabled: Yes
Locked: No
Allow Edits: Yes

Does anyone have any ideas why I can not enter data in these 6 fields?

Thanks
Simon

 

[Keith Wilby]

Good Evening,

I have a form with a Record Source of a Query and 10 fields that have a
Control Source from this Query. I have an additonal 6 fields on this form
which are Unbound and I would like to enter data into these fields.

When I view this form, the 10 fields are populated as expected, but I can
not enter data into the Unbound fields.

Enabled: Yes
Locked: No
Allow Edits: Yes

Does anyone have any ideas why I can not enter data in these 6 fields?

Firstly, a field is a property of a table, you do not have fields on a form.
What you have on a form are controls (text boxes et al). Because your 6
controls are unbound they have no field in which to store data. The
solution is to bind these controls to a field.

HTH - Keith.
www.keithwilby.com

 

[Simon]

Thanks Keith,

On a button click, I open a Recordset to the table were I want to store the
data and then populate the table fields with the values from the Unbound
controls on the form. This method works well on others form - I do this
becuase I do not know better.

If I bind the controls, will I not see all data in the table?
Were I actually just want blank controls/fields.

Also, can I bind fields on the same form to 2 different tables?

Thanks
Simon

 

[Keith Wilby]

Hi Simon ...

Thanks Keith,

On a button click, I open a Recordset to the table were I want to store
the
data and then populate the table fields with the values from the Unbound
controls on the form. This method works well on others form - I do this
becuase I do not know better.

If I bind the controls, will I not see all data in the table?

Yes you will but you can set the form's "Data Entry" property to "Yes" so
that you won't.

Were I actually just want blank controls/fields.

Also, can I bind fields on the same form to 2 different tables?

If you include both tables in a query you can then bind your form to that
query, assuming that the tables are related to each-other.

HTH - Keith.
www.keithwilby.com