Grid control only displays 1 record

  • Thread starter Thread starter Finance guy
  • Start date Start date
F

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.
 
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.
Click to expand...
Grid control? What grid control?

mfG
--> stefan <--
 
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
 
:

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.
Click to expand...

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.
 
Tom van Stiphout said:
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
Click to expand...
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.
 
Back
Top