Forms and Subforms

[dcjones]

Hi all,

I have a Form with a subform attached.

I will call them "mainForm" and SubForm1".

In SubForm1 I have another SubForm which I will call "SubForm2"

****** Running SubForm1 on it's own. *******

On SubForm1 I have a Combo box which looks up details from a table.
When the user selects a record in the Combo box the details appear in SubForm2.

I have the following code behind the Combo box:

Private Sub Combo88_Change()
DoCmd.Requery
End Sub

This does a refresh on SubForm1 and the correct details appear on SubForm2.

But, when I run the MainForm containing both the SubForms I get an error when the user selects a record from the Combo box on SubForm1.

The Error:

Run-time eorror "2488"
You can't use the ApplyFilter action on this form.

How can I make SubForm1 refresh to show the correct details on SubForm2.


Any Help would be good.

Kind Regards, keep safe and well.

Dereck

 

[dcjones]

Thanks for the Reply Pat.

Another question if I may.

I have a combo box on the form. how do I clear the contents of the combo box using a command button.

Thanks again

Kind Regards, Keep safe and well.

Dereck

 

[dcjones]

Hi Pat,

Thanks for your reply. Just what I needed.

Why is it the simple things are so invisible.

Many Thanks

Regards, keep safe and well.

Dereck