SUBFORM DOES NOT REQUERY RECORDSET

[DougLubeyLouisiana]

SCENARIO:
I HAVE A MAIN FORM WITH TWO OBJECTS IN IT:
A TEXT BOX AND A SUBFORM

I ENTER A VALUE INTO THE TEXT BOX AND WANT TO
REFRESH THE SUBFORM BASED ON WHAT I ENTER IN THE
TEXT BOX.

PROBLEMS: THE SUBFORM IS BASED ON A ADO RECORDSET
AND YOU SEE DATA IN IT WHEN IT IS OPEN SEPARETELY
FROM THE MAINFORM.

BUT WHEN i TRY TO REQUERY THE SUBFORM( BUILT FROM A
RECORDSET) THE INFORMATION DOES NOT GET REQUERIED.

textbox_ONEXIT()
SUBFORM.REQUERY
END

I GET NOTHING....

tHIS IS WHAT i TRIED:
**REOPENING THE RECORDSET ON_CURRENT EVENT IN THE
SUBFORM EVENT.... NOTHING

 

[Terpsfan]

I think you are requerying the wrong thing. I think you are supposed to requery the recordset object that is the underlying data to the subform. Try that and see if it works.

 

[raymondo]

Suppose the name of the recordset is rsMyRecSet.
Try rsMyRecSet.Requery

 

[RottPaws]

Try subform.form.requery _________
Rott Paws

...It's not a bug. It's an undocumented feature.