Recordset clone method

[Milan]

Hi People!,

i have the following code :

Dim RstCatAType As DAO.Recordset
Set RstCatAType = Me.RecordsetClone

RstCatAType.FindFirst "CategoryA = '" & Me!CmboCategoryA & "'"
Me.Bookmark = RstCatAType.Bookmark
Set RstCatAType = Nothing


Which i bound to the afterupdate event on a combobox. The code work fine when it is the only form open, however when the form is open form a switchboard menu, it errors because the switich board form is still open . How can i get it to run whilst another form is open in the background, I.E the switchboard. Can this be done ?

Would be grateful for any help here please.

Thanks

Milan

 

[billyr]

Did you create your switchboard using the wizzard?
Try this. Create a form with just a cmd button. Open your form with the cmd button. If your form works OK this way, check the way your switchboard is opening the form. Seems like I've had a similar problem and it related to the mode my switchboard opened another form in.

 

[Milan]

Hi, Guys,

Thanks!! got it sorted!!!. It was the mode in which the switchboard was trying to open the form. Their are a number of select case statements that determine the mode a form is opened. Thanks for the help!!!

 

[Milan]

Woops!!,

Sorry Pat!!! did not mean to call you a Guy!!

Milan