Form Recordset in Access 2007 Returning no data

Question

I'm building a form in access that has a several sub-forms in a tab control The sub-forms are working fine, but when I set the parent form's Record Source property and bind a few Text Boxes to the data, I find that a null recordset has been returned.

I've tried this with several different queries (each of which works in a separate query designer) to no avail. I've also tried binding the form to a Table directly and a null recordset is still returned.

I've checked the filters and they are turned off.

Answer 1

Have you tried executing a Requery on your parent form:

Me.RecordSource = "someQuery"
Me.Requery

?

Answer 2

If the Text Boxes that are bound to data are Locked and Disabled then the query will return a null dataset by default.

The form's 'Data Entry' property also needs to be set to false. Setting it to true will make the form for data entry only. This prevents any data that might be returned by the background dataset from appearing when the form loads.

Answer 3

Can you unlock and/or enable the fields before setting the data source?