Auto Populate (Copy) fields based on the selection from other fields - Enables Edit

[djossh]

how to autopopulate other fields in my form based on the value of other fields..

1. I have 10 combobox field in my forms.. I need to autopopulate all other fields based on the selection i made on the first field.

2. there are times that i need to change the value in other fields..in my example below i need to change field # 6 & field# 9..

Field----Value
1 ------X123 == (First Field == Selection ==> autopopulate other Fields)
2 ------X123
3 ------X123
4 ------X123
5 ------X123
6 ------O554 ====> (from X123 - change to O554)
7 ------X123
8 ------X123
9 ------M887 ====> (from X123 - Change to M887)
10 -----X123

Im new to MS Access and don't know how to do this. Thanks

 

[Khalid_Afridi]

you can do that in VBA code for the desired field based on the selection of a combo box.

An After_Update Event of the combox box should handle this:

Private Sub YourCombo_AfterUpdate()
me.YourField.Value = me.YourCombo.Column(0)
End Sub

me.YourCombo.Column(0) could be differ based on your combo values you have. it could be column(0) or column(1) or column....

 

[djossh]

you can do that in VBA code for the desired field based on the selection of a combo box.

An After_Update Event of the combox box should handle this:



me.YourCombo.Column(0) could be differ based on your combo values you have. it could be column(0) or column(1) or column....

Thank you..