CommandButtons

  • Thread starter Thread starter SusanM
  • Start date Start date
S

SusanM

Using the command button wizard "go to next record" not
working. Getting same error message on all record
navigations for my form. "Ambiguous" is the main word in
the message. Something wrong with form maybe? Another way
to delete, add, go to previous etc...? Thanks Everyone.
Have a good evening.
SusanM
 
Hi Susan

what is the record source for your form?
(view the form in design view / choose from the menu View / Properties - in
the dialog box that pops up make sure it says "form" on the blue line - if
not there should be a drop down box on your toolbar with one of the options
being form - then go to the "All" tab - right up the top is record source -
click in here & copy & paste it to your post.)

this might assist in determining what is happening.

Cheers
JulieD
 
It usually means that you have used the Wizard twice and there are 2 copies
of the CommandButton_Click Event procedure code. For example, you used the
Wizard to create the CommandButton then deleted the CommandButton (the code
was not deleted). If you then use the Wizard to create the CommandButton
with the same name again, you will have duplicated code.

Check the code module of the Form and delete the duplicated code. Make sure
you compile the code to eliminate all Compile Errors.
 
Back
Top