Help

  • Thread starter Thread starter Jason Fraze
  • Start date Start date
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
 
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
 
Back
Top