Have Geek Brain

Recordset Form in Access 2007 Returning Data

I am creating an accessible form that has multiple sub-forms in a tab control. The subforms work fine, but when I set the "Record Source" property of the parent form and bind multiple text fields to the data, I found that a null recordset is returned.

I've tried this with several different queries (each running in a separate query builder) to no avail. I also tried to bind the form to the table directly and an empty recordset is still returned.

I checked the filters and they are disabled.

+1


a source to share


4 answers


If data-bound text fields are locked and disabled, the query will return a null dataset by default.



The Data Input Property must also be set to false. Setting it to true will make the form enter data only. This prevents any data that might be returned by the underlying dataset when the form is loaded.

+1


a source


Have you tried to execute the query in your parent form:

Me.RecordSource = "someQuery"
Me.Requery


?

0


a source


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

0


a source


Try checking the relationships in your tables, especially if you've used the auto search option to create relationships. Open tables in design mode and check if your foreign keys (FK) are indexed correctly (in field properties). If they are indexed, make sure you have the correct index type for that particular field. Example; TABLE A with the following columns PatientID (PK), PatientName, and TABLE B with column IDs, PatientHeight, PatientWeight, PatientBP, PatientID (FK) For such table B, if you have "PatientID (FK) indexed with" duplicate OK ", you will get a RecordSet error when using these fields associated with this table in the form, especially if the form is concatenating fields from multiple tables. So try checking the indexing of your fields,especially if they match their type of relationship

0


a source






More articles:


All Articles