Combo Box

[letsaccess]

Hi All,

I have Form and subform for classes , in the subform I have combo box and I want instead the user select the name from combo box I want the result appears in all column automatically and the user just update the degree like illustrated in screenshot,
ScreenShot: prnt.sc/d5xf0a

Thanks for help.

 

[Ranman256]

In the cbo AFTERUPDATE event, run an update query to put the cbo in all the fields using the key in the master form.

The query in the sub form is qsSubFrm...so...
Update qsSubFrm set [field] = forms!main!subform!form!cboBox

 

[letsaccess]

sorry Ranman256 I didn't understand exactly what must I do , could you please explain more ,
Thanks you .

 

[Ranman256]

make an update query to alter the fields you want....quAlterFields
this query uses the query YOU have in the subform... qsSubFrm
qsSubFrm is the query bound to the sub form to show the data.


then the event for the combo box., the event is afterupdate, this code will run when the user changes the combo box
in the event , run the update query

sub cboBox_afterupdate()
   docmd.runquery "quAlterFields"
end sub

use the code above or use a macro to do it.

 

[Uncle Gizmo]

I don't think you are approaching the problem correctly. I draw your attention to this article:- Excel In Access It shows an alternative approach..