Default control value from query 1

[claims]

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

 

[PHV]

In the AfterUpdate event procedure of FieldA:
Me!FieldB.Locked = False
Me!FieldB.Value = Me!FieldA.Column(2)
Me!FieldB.Locked = True
Me!FieldC.Value = Me!FieldA.Column(2)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[claims]

Thanks a mil! It worked!