macro to new record wont work

[xena_morph]

for some reason my macro to jump to a new record for entry in a form doesnt work instead it just goes to the first record and overwrites why???

 

[BukHix]

Are you sure the correct event is being used for the trigger?

 

[xena_morph]

at present its a macro which runs on the onclick event

the macro at present states to:
opentable--->properties
openform--->add new property
gotorecord ---> new
close --> form--->main

any suggestions, ive tried it opening next file all to no avail argh!!!

 

[kilroyscarnival]

at present its a macro which runs on the <<onclick event
the macro at present states to:
opentable--->properties
openform--->add new property
gotorecord ---> new
close --> form--->main

any suggestions, ive tried it opening next file all to no avail argh!!!>>

Have you tried adding another
"gotorecord ----> new" BEFORE adding the new property?

Trying to visualize, but it seems you didn't tell it to go to a new record till after you did the add.

--Ann

 

[xena_morph]

that doesnt work, i just dont uderstand why a simple command on an onclick event doesnt work, it should be so easy

open the table up go to a new record space open the form up referring to that record space and add whilst closing the last form argh!!!!

 

[xena_morph]

ive just figured it the data mode in the form that the data was to be added on needed to be set from blank to add

isnt it amazing how little things can irritate you