I have a MS Access form (frmEntry)with three fields that I want updated based on the value of one field:
FieldA (drop-down list from query with columns A-Autonumber, B-Text String, C-Different Text String, D-Another Different Text String) this field is bound to "A", but column widths are set to display "B"
FieldB (text) I want to display and store the value in this control from column "C" as chosen for FieldA. Stored, but not able to be edited from the form.
FieldC (text) The same as FieldB, but able to edit the defaulted value.
The user should be able to simply chose from the drop-down list for FieldA so that FieldB & FieldC default, with FieldC able to be edited.
Please help!
Thanks
FieldA (drop-down list from query with columns A-Autonumber, B-Text String, C-Different Text String, D-Another Different Text String) this field is bound to "A", but column widths are set to display "B"
FieldB (text) I want to display and store the value in this control from column "C" as chosen for FieldA. Stored, but not able to be edited from the form.
FieldC (text) The same as FieldB, but able to edit the defaulted value.
The user should be able to simply chose from the drop-down list for FieldA so that FieldB & FieldC default, with FieldC able to be edited.
Please help!
Thanks