Strange behaviour in subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Using Office 2003 and Windows XP;

I have an unbound subform on a form that I am attempting to populate using a
SQL string as follows:

Me!sfrmMainData2.Form.RecordSource = sSQL

The subform acts as though it contains data in the sense that the record
counter at the bottom shows the correct number of records; the scroll bar
activates and I can scroll down the list and the currently selected record
count lights up on the right like a tooltip; and the on the left side the
square blocks you can click to select a record show up in the same count as
the number of records, but no data appears and the whole interior of the
subform is blank; like blacked out.

Does anyone have a clue what is going on or what I'm doing wrong? If so,
please post back what I need to do to correct this issue.

Thanks much in advance.
 
What happens when you include following statement:
Me!sfrmMainData2.Form.Refresh

Krgrds,
Perry
 
Hi Perry,

Nothing happens; I also have a "Requery" command in there as follows:

Me!sfrmMainPSFT.SetFocus
Me.sfrmMainPSFT.Form.RecordSource = sSQL
Me!sfrmMainPSFT.Form.Requery
Me!sfrmMainPSFT.Form.Refresh

Any other ideas? I'm going crazy here...
 
The only thing that I think of:
Mainform/subform - LinkChild-/LinkMasterFields relation is broke.

If you rebind yr subform using another recordsource, are the fields
available for mainform/subform (LinkChild- and LinkMaster flds)
in the new recordsource?

If not, you will also have to re-assign these settings when rebinding yr
subform.

Krgrds,
Perry
 
Back
Top