[AccessD] Cannot set recordsource on Load Event

Randall,

I would always use the Open event of the form, rather than the Load 
event, to manipulate the Record Source.  Not sure whether that will make 
a difference, but waiting until after the data is populated seems a bit 
late in the day to be telling it which records to include.

The OpenArgs property is text, not numerical.  Therefore, your code 
should read:

Private Sub Form_Open(Cancel As Integer)
     If Me.OpenArgs = "1"
         Me.RecordSource = "Audit_Data_Med"
     Else
        Me.RecordSource = "Audit_Data_MH"
     End If
End Sub

Randall Anthony wrote:
> So, setting the recordsource (no matter where) triggers the oncurrent?
> Therefore bypassing the set criteria?