Hi,
I'm having issues with a form (named 'search') I am trying to build.
The form looks like this:
the first OK button linkes to macro1
the second OK button linkes to macro2
What I want is to print a report of the name I enter.
Both name1 and name2 have an OK button. I have 2 seperate macro's. When I try to execute the macro's directly (not from the OK button in the form) they work fine.
The issue I'm having is as following:
When I type in John Doe in the name2 field and press the OK button it prints me the report from John Doe.
When I select John Doe in the name1 field and press the OK button it prints me an empty report, so it cannot find the name.
Now why can't it find the name? The macro's look as following:
Macro1: [name]=[Forms]![search]![select_name]
Macro2: [name]=[Forms]![search]![typin_name]
I'm having issues with a form (named 'search') I am trying to build.
The form looks like this:

the first OK button linkes to macro1
the second OK button linkes to macro2
What I want is to print a report of the name I enter.
Both name1 and name2 have an OK button. I have 2 seperate macro's. When I try to execute the macro's directly (not from the OK button in the form) they work fine.
The issue I'm having is as following:
When I type in John Doe in the name2 field and press the OK button it prints me the report from John Doe.
When I select John Doe in the name1 field and press the OK button it prints me an empty report, so it cannot find the name.
Now why can't it find the name? The macro's look as following:
Macro1: [name]=[Forms]![search]![select_name]
Macro2: [name]=[Forms]![search]![typin_name]
Last edited: