Need to run a macro that filters only current record

[mikedcruz]

I have a very simple form with some command buttons that open other forms which I want to contain data related only to the active record. Currently, the forms that open with the macro only open with the first record in the database no matter which record I'm viewing on the main form. Can anyone help me set up the correct filter in the macro for this? Thanks much.

 

[Sergeant]

Try this:
Turn on your controls tool box wizard.
Put a new button on your form.
Read the wizard as you step through it, and you can't go wrong.