Good afternoon experts,
I am creating an Access database to hold training dates for the hospital I work at. I put in the ability to filter the records by clinic. The problem I am having is when changing from one clinic to another the first overall record is showing, instead of the first record from that clinic. I am not sure if I need to change the forms record source but I am not entirely sure how to do that programically either. I figured I could do something along the lines of;
Select Case Me.cboSectionChange
Case 1 To 38
Me.Form.RecordSource = "qryFilterRowSourceAll"
QryFilterRowSourceAll: SELECT blah FROM blah WHERE dbMaster.Section=Forms!formMaster!cboSectionChange;
Any suggestions on how to get this working correctly or a more efficient means of getting this task accomplished would be appreciated.