Solved Filter Drop Down Issue When Form Pop-Up Property Set to Yes

[Pac-Man]

Hi,

I am using attached Microsoft Template and when I set the Pop-Up Property of "Account Transaction List" form to yes and open this form, filter on the top right corner do not show the row entries of combo box. When this property set to NO then it show the row entries. Can anybody please look in to it and help me figure out the reason and issue because I want to use the form in POP UP mode.

Best Regards,
Abdullah

 

[CJ_London]

the problem is the use of currentobjectname in your rowsource - when the form is a popup, it is not the current object - see this link

Application.CurrentObjectName property (Access)

Office VBA reference topic

docs.microsoft.com

to fix, in your form open event put

cboFilterFavorites.RowSource = Replace(cboFilterFavorites.RowSource, "[application].[currentobjectname]", "'" & Me.Name & "'")

 

[Pac-Man]

That amazing. It works. Thanks a lot @CJ_London

 

[Pac-Man]

Hi,

How can this filter method be applied on a form with subform (emulated split form) instead of split form?

 

[CJ_London]

in the main form open event, refer to your main form controls as already done. For subform controls use

me.subformname.form.controlname

I use this basic technique frequently, but usually would use a placeholder in the sql (e.g. [frmName]) rather than [application].[currentobjectname]

 

[Pac-Man]

Thanks for reply. I'll try to implement it.