Opening a Form with Command Button

[TMelone]

I have tried to add a command button to a simple form that
will open another form for data entry. Everytime I click
on it I get this message:
"The expression on load you entered as the event property
setting produced the following error: Ambigous name
detected:find_record_click.

When I hit OK the form correct form then opens. Any
suggestions?

TM

 

[Dirk Goldgar]

I have tried to add a command button to a simple form that
will open another form for data entry. Everytime I click
on it I get this message:
"The expression on load you entered as the event property
setting produced the following error: Ambigous name
detected:find_record_click.

When I hit OK the form correct form then opens. Any
suggestions?

It's telling you you have multiple procedures named "find_record_click"
in your form's code module. Open the module in the VB Editor, set the
code window for Full Module View (using the buttons at the bottom left
corner of the module window), and look through the code for the
duplicate procedure. Assuming you find more than one (which I expect),
choose which one to keep and delete the other(s).