Search or Filter form using embedded macro

[aiikahn]

Good evening, everyone! My company has disabled vba for our access database due to security reasons so I've only been able to use embedded macro actions for a tracking database I've created recently to better organize our electronic records.

I'm trying to create a search form in which I could display or filter the results in a subform (or multi-item form) similar to the search/filtering field in the navigation button.

I've search through the forum and around the internet but only found VBA-type solutions. Unfortunately, I can only use embedded macro actions. I was wondering if anyone may be able to assist me with this?

Thank you in advance for your assistance!

 

[Beetle]

What version of Access?

Can you post an example db with dummy data? If not you'll need to describe in more detail how your forms are set up, what data you're trying to filter, and how you want to perform this functionality (i.e. you want to click a command button, or whatever).