I am trying to make selecting information easier on my form so I'd like to have combo boxes that update after a selection has been made.
I have a combo box that displays names of audits. The row source has this query in it:
SELECT [tbl_Audit].[Audit_ID], [tbl_Audit].[Audit_Name] FROM tbl_Audit ORDER BY [Audit_Name];
I want a second combo box to be based off the tbl_audit.audit_id that a user selects. I want to be able to show
SELECT tbl_observation.obs_id FROM tbl_observation, tbl_audit WHERE tbl_observation.audit_ID = the value that the user selected from the combo box above
I was thinking of whether this could be done just using the after updates or before update spots in the Properties boxes or if this had to be done with VB?