The RecordSource is a simple "SELECT field1, field2, field3 FROM table WHERE field1=value". I am not passing a WHERE clause in my DoCmd.OpenForm statement. The where clause is set programmatically in the Open even of the form (I make sure to Requery) with the value of the where clause being passed via OpenArgs.
Using Debug.Print on the form's RecordSource (actually via Timer, just to be sure nothing is changing it after the Open event) returns a SQL string which I can then plug in to query design and verify that there are in fact records, yet they fail to populate in the form (Debug.Print on the form's Recordset.RecordCount yields 0).
I am able to add/edit records to the table the query references using the bound controls on the form. The form has a blank filter, is not set to filter on load, and does not allow filters. So, I can't imagine that is messing things up.
I've noticed that not using a where clause will correctly return all records in the table and populate the bound form controls. Very confused.
Using Debug.Print on the form's RecordSource (actually via Timer, just to be sure nothing is changing it after the Open event) returns a SQL string which I can then plug in to query design and verify that there are in fact records, yet they fail to populate in the form (Debug.Print on the form's Recordset.RecordCount yields 0).
I am able to add/edit records to the table the query references using the bound controls on the form. The form has a blank filter, is not set to filter on load, and does not allow filters. So, I can't imagine that is messing things up.
I've noticed that not using a where clause will correctly return all records in the table and populate the bound form controls. Very confused.