Requery not working on Tab Form 1

[cmmrfrds]

I am requering a listbox after the user has made a selection to turn off the selection. Maybe there is a better way to do it, but it works on a stand alone form but not when I add the Form to a Tab Form. SEE CODE. The error is: &quot;apply filter&quot; not allowed. when the &quot;Yes&quot; path is followed on the if.<br>
<br>
'--- Do requery depending on where invoked from<br>
Dim FormToCheckFor As String, retmsg As String<br>
FormToCheckFor = &quot;MotorDataEntry&quot;<br>
retmsg = SeeIfFormLoaded(FormToCheckFor)<br>
If retmsg = &quot;Yes&quot; Then<br>
'''Forms!MotorDataEntry.AllowFilters = True<br>
DoCmd.Requery &quot;Forms!MotorDataEntry!CBAccessoryType&quot;<br>
Else<br>
DoCmd.Requery &quot;CBAccessoryType&quot;<br>
End If<br>
<br>

 

[WP]

Try using the requery method.<br>
<br>
controlname.requery<br>
<br>
or forms!formname!controlname.requery<br>
<br>
WP <p>Bill Paton<br><a href=mailto:wpaton@neptune400.co.uk>wpaton@neptune400.co.uk</a><br><a href=

http://www.neptune400.co.uk>www.neptune400.co.uk</a><br>

 

[cmmrfrds]

Thanks WP. It solved the problem!!<br>
<br>
Using the &quot;method&quot; worked in both instances of standalone or in the tab form. When I first tried the method I got a different error but it allowed me to see that I was missing a level in my Form hierarchy. I went back and tried the DoCmd again but it still gave me the same error message. Thanks again.

 

[elizabeth]

I think you need forms!formname!tabname!controlname.requery

 

[cmmrfrds]

That is what I used. Here is the code that worked.<br>
<br>
Forms!MotorDataEntry!tabsubformEquipmentAttachments!CBAccessoryType.Requery