Here's what worked for me to give me a blank form when the form is first loaded:
Private Sub Form_Load()
Me.Form.RecordSource = "SELECT * FROM [qryProdMaster] WHERE PMSiteID = 0"
End Sub
The key in the above RecordSource is the 'PMSiteID = 0'. I have no ID with 0 so it gives me a...