Problem related to saving a record

[v5652]

hi friends,

i have one problem related to saving a record.
i use access 2000.
i use the following command to save the record

docmd.Recordsmenu, acsaveRecord,,acMenuVer70

but some times it gives the error 'The save command isn't available now'.

and record couldn't saved.

so i have used 'acMenuVer20' it works find but everytime i click on save button it displays 'About Microsoft Access' window and i have to click on ok button then it is being saved.

if anyone has the solution pl reply.

thanks.

 

[RoyVidar]

Allen Browne talks a little about what can happen with different methods of saving when you close a form

http://allenbrowne.com/bug-01.html

I'll use the following, which is supposed to be reliable

[tt]if me.dirty then
me.dirty = false
end if[/tt]

which first checks whether there are unsaved changes (form is dirty), then saves.

Roy-Vidar

 

[v5652]

thanks RoyVidar.

i will try this.
thanks