inputing data in a form

Hi,

I have made a form with 2 como boxes and 2 input fields. The combo boxes
are each linked to a field in a table. I can select the choices that I was
from the combo boxes but then I am not able to type anything in the 2 input
fields. In the end I wanted to select information from 2 different tables to
update to the form via the combo boxes and then manually input the 2 fields
and have all 4 fields in the form update to a table.
Does anybody know how to do this??

Thanks,
Sarah

Sarah,

One of the things most new Access users, including me, miss is the
distinction between form (or report) *controls* (textboxes, combo boxes,
checkboxes, etc.), and *fields*. The latter exist only in a table, and have
a datatype--Text, Numeric, Yes/No, etc.

Form and report controls do not have a data type, and are simply containers
that display and receive data. The data may be a string literal, the result
of an expression, or the data contained in a field in the form's RecordSource.

To store data in a field, all that is required is that the form's
RecordSource property be set to the name of a table or query that contains
all the fields of interest, and that the specific control's ControlSource
property be set to the name of the field. Whatever is entered into the
control will automatically be stored in the underlying field.

Several properties could prohibit entering or changing data on a form:

- the form's AllowEdits, AllowAdditions, AllowDeletions properties
- the control's Enabled, Locked, and Visible properties

If the form is being opened by code, the form properties could be set by an
optional OpenForm method parameter, and all could be set explicitly either by
the calling procedure or the form's OnOpen, OnLoad, OnActivate, or OnCurrent
event procedures.

Hope that helps.
Sprinks


"Sarah Kegel" wrote:

Hi,

I have made a form with 2 como boxes and 2 input fields. The combo boxes
are each linked to a field in a table. I can select the choices that I was
from the combo boxes but then I am not able to type anything in the 2 input
fields. In the end I wanted to select information from 2 different tables to
update to the form via the combo boxes and then manually input the 2 fields
and have all 4 fields in the form update to a table.
Does anybody know how to do this??

Thanks,
Sarah