executing macro by form

JamieC

New member
Local time
Today, 04:44
Joined
Apr 22, 2006
Messages
7
Hi,

I'm having issues with a form (named 'search') I am trying to build.

The form looks like this:
1.jpg


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:

Users who are viewing this thread

Back
Top Bottom