If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
inputing data in a form
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 |
Thread Tools | |
Display Modes | |
|
|