Help

J

Jason Fraze

I have a form. and under form properties I created a
macro in "before update". The macro is called " update
date". The action is "setbalue" the item is "[Forms]!
[MSDS TAB QUERY]![modDate]" and the expression is "Date()".
The macro runs great. The problem is as follows. After I
update the values in the form I want to hit a command
button for print preview and when i do this the date is
still the old date. If i close the form and reopen it the
date is changed and i can print it just fine. How can i
print the report for this form with out closing and
reopening the form?

Thanks for you time and help

Jason Frazer
 
M

May

if you use "before update" on the form, the data never be
updated unless you close the form or move to the next
record, that's the reason why!!!
try to put the same macro on the print preivew on_click
command then print preview or
add an action in macro "runcommand", key
in "acCmdRefresh", then your print preview action

May
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top