I have a form and I want the record source of a dropdown box to change based on a criteria.
as an OnOpen, I have:
If Forms![frmMainMenu]![RepairAccess] = "Yes" Then
Me.TransactionID.RecordSource = "Qry_Restricted_TransactionType"
Else
Me.TransactionID.RecordSource = "Qry_All_TransactionTypes"
End If
I have also tried as a BeforeUpdate event on the dropdown box field itelf:
If Forms![frmMainMenu]![RepairAccess] = "Yes" Then
Me.RecordSource = "Qry_Restricted_TransactionType"
Else
Me.RecordSource = "Qry_All_TransactionTypes"
End If
Each version creates errors and I have resorted to guess and check. Any help will be apreciated.