I have a combo box ("severity")that uses a value list as it's row source type. The
options in it are 1, 2, 3, or 4. I want have one of these items to
automatically populate this combobox depending on what is selected in a box
The "Comments" combobox is based on a query with a SQL of: SELECT tblComments.
Comments, tblComments.CmntAreaCode, tblComments.CommentID FROM tblComments
WHERE (((tblComments.CmntAreaCode)=Forms!frmObservations !frmLO_Details.Form!
CmntAreaCode)) ORDER BY tblComments.CmntAreaCode;
you do not need a combobox for Severity if the Severity value is in the Comments combox's underlying record source.
instead put an unbound text box Severity on the form and set its source to be:
am guess at the column being two as the column count begins at 0 if pre Access 07; obviously modify as appropriate to your actual syntax....but this will work - whenever someone changes the Comment choice in that combobox the value in the Severity text box will change too....