How to get rid of warning during dynamic update?

[BFP]

Hello All.<br><br>I have a form with a subform.&nbsp;&nbsp;In both, I allow new entries by double-clicking in the appropriate combo box (which opens up yet another form for entry).&nbsp;&nbsp;As part of the dynamic update, I also perform a re-query on the combo box.<br><br>This works fine while I am working in the form, but if I do an update in the subform, I get the following message:<br>&quot;You can't use the ApplyFilter action on this window.&quot;<br><br>Everything seems to work, but it's annoying to get this warning each time...<br><br>Thanks in advanced,<br><br>--Dan

 

[Guest_imported]

Dan, when u get an answer to this do let me know as i have same problem...&nbsp;&nbsp;&nbsp;damned annoying eh?&nbsp;&nbsp;&nbsp;lol<br><br>Cheers, Jon

 

[DougP]

Lets see the code you are uing for your requery.<br>For all of it as a matter of fact.<br>Copy and paste it here.<br> <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.

 

[BFP]

Hi Doug.<br><br>Here is my procedure:<br>Private Sub Combo21_DblClick(Cancel As Integer)<br>On Error GoTo Err_Combo21_DblClick<br>&nbsp;&nbsp;&nbsp;&nbsp;Dim ctl As Control<br>&nbsp;&nbsp;&nbsp;&nbsp;<br>&nbsp;&nbsp;&nbsp;&nbsp;DoCmd.OpenForm &quot;Problem Sub-Categories&quot;, acNormal, , , acAdd, acDialog<br>&nbsp;&nbsp;&nbsp;&nbsp;Set ctl = Me!Combo21<br>&nbsp;&nbsp;&nbsp;&nbsp;DoCmd.Requery &quot;Combo21&quot;<br>&nbsp;&nbsp;&nbsp;&nbsp;<br>Exit_Combo21_DblClick:<br>&nbsp;&nbsp;&nbsp;&nbsp;Exit Sub<br><br><br>Best Regards,<br><br>--Dan<br><br>Err_Combo21_DblClick:<br>&nbsp;&nbsp;&nbsp;&nbsp;MsgBox Err.Description<br>&nbsp;&nbsp;&nbsp;&nbsp;Resume Exit_Combo21_DblClick<br>&nbsp;&nbsp;&nbsp;&nbsp;<br>End Sub

 

[JimConrad]

Try changing:<br><br>Set ctl = Me!Combo21<br>DoCmd.Requery &quot;Combo21&quot;<br>&nbsp;<br>To:<br><br>Combo21.Requery&nbsp;&nbsp;&nbsp;&nbsp;<br><br> <p>Jim Conrad<br><a href=mailto:JimConrad@Consultant.com>JimConrad@Consultant.com</a><br><a href= > </a><br>