Label Print Query?

[GJT]

For printing labels I have a form bound to a table. I only ever need 1 record in this table. This record holds the label data I wish to print on the label.

On the form is a print button that calls the Label report.

I do not have / wish to have, record navigation buttons and therefore I am asking if I can force any changes to the underlying table by way of script? Presently, user changes record data by way of 'bound' text fields , close form (changes are saved to table), re-open form - press 'Print ' button, label preview displays correctly.

(If data is changed and print is activated - the previous data is displayed - incorrect....)

Thanks in adv. for any help.

 

[namliam]

You could add a save command before printing....

Regards

The Mailman

 

[GJT]

? - Save what? What command do you use?

 

[namliam]

Closing the form causes an implicit save. Just before opening the report (docmd.openreport) you could add a save command to save the changes just made to the record. (Docmd.save i think should do the trick)

Regards

 

[GJT]

Unfortunately not, the Save action simply saves table design/form design /report design changes........

 

[Rich]

DoCmd.RunCommand acCmdSaveRecord

 

[namliam]

DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70

As taken from a wizard created command button for saving records...

Regards

 

[Rich]

The DoMenuItem method has been obsolete for years and should not be used anymore. Mind you MS has been saying that since 96? It would seem that one part of the Access development team doesn't speak to the other

 

[namliam]

The DoMenuItem method has been obsolete for years and should not be used anymore. Mind you MS has been saying that since 96? It would seem that one part of the Access development team doesn't speak to the other

Appearently so, but then what is the "correct"/better statement to save the current record?

 

[Rich]

I already posted it
DoCmd.RunCommand acCmdSaveRecord

 

[namliam]

hmz, that was a nice crosspost there ... Exactly seconds later... sorry for missing that....

 

[GJT]

Thanks chapz! Sorted