Auto save and print

[Guest]

I am entering data into a form, via a wedge scanner. I have the properties
set so that when the data is entered, the auto tab function moves the curser
off of the field and prints a report. The problem is I can not get access to
save the current information in the field. I have tried various save
functions, but none seem to work. How can I automatically save the current
data in the form before the report is generated?

 

[Guest]

Have you tried

DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70

before printing

 

[Guest]

Itried that and it still does not save the record, the only way I can get the
record saved is to activate the button that drives that code.
Thank you very much for your help.

 

[Rick Brandt]

I am entering data into a form, via a wedge scanner. I have the
properties set so that when the data is entered, the auto tab
function moves the curser off of the field and prints a report. The
problem is I can not get access to save the current information in
the field. I have tried various save functions, but none seem to
work. How can I automatically save the current data in the form
before the report is generated?

Try...

Me.Dirty = False

 

[Joseph Meehan]

I am entering data into a form, via a wedge scanner. I have the
properties set so that when the data is entered, the auto tab
function moves the curser off of the field and prints a report. The
problem is I can not get access to save the current information in
the field. I have tried various save functions, but none seem to
work. How can I automatically save the current data in the form
before the report is generated?

Sorry. This is a newsgroup dedicated to questions about Access, the
database program in Office Professional. It appears your question may not
be related to these subjects. The Microsoft help system is not all that
clear and may have misdirected you here.

It is best to ask your questions in a newsgroup dedicated to the
subject of your question. You should find people better able to address
your problem there.

Note: It is always best to indicate the name and version of any
program(s) you may be using when asking a question and also indicate the
operating system (like Windows XP or 98) when you ask a question.