Grid control only displays 1 record

[Finance guy]

I have a form with a subform that has a grid control. If I run the sql for
the recordsource of the grid control in an access query, many records are
returned. However, only one record displays in the gridcontrol.

ANy assistance appreciated.

 

[Stefan Hoffmann]

hi,

I have a form with a subform that has a grid control. If I run the sql for
the recordsource of the grid control in an access query, many records are
returned. However, only one record displays in the gridcontrol.

Grid control? What grid control?

mfG
--> stefan <--

 

[Tom van Stiphout]

On Wed, 24 Mar 2010 07:21:02 -0700, Finance guy

Do you mean the subform control in datasheet mode?
Check the LinkMasterFields and LinkChildFields properties of the
subform control. Perhaps also the subform's Filter property.

-Tom.
Microsoft Access MVP

 

[Finance guy]

:

Do you mean the subform control in datasheet mode?
Check the LinkMasterFields and LinkChildFields properties of the
subform control. Perhaps also the subform's Filter property.

Yes, the subform control in datasheet mode. The LinkMasterFields and
LinkCHildFieldProperties were set to to a field. I've removed it and still
can only get it to display one record.

 

[Finance guy]

On Wed, 24 Mar 2010 07:21:02 -0700, Finance guy

Do you mean the subform control in datasheet mode?
Check the LinkMasterFields and LinkChildFields properties of the
subform control. Perhaps also the subform's Filter property.

-Tom.
Microsoft Access MVP

Thanks Tom, I set the Filter to "", and the LinkChildFields and
LinkMasterFields to "" in code at run time. That seems to have solved my
issue.