on lost focus - update 1

[hefly]

I have a command button driving an event on a form "Preview Print"

When the entry field looses focus, I would like the field to update, so the results of the entry will display on the print preview.


If try to create an event, I get a VBA script:

Private Sub Text102_BeforeUpdate(Cancel As Integer)

End Sub

The Macro builder doesn't have an option for the action 'on lost focus update'

How can I get my form to update when the print preview command button is clicked?

Hefly

 

[KenReay]

Hi

How can I get my form to update when the print preview command button is clicked?

In the on_Click event of the command button, before the docmd.openreport, put the line

DoCmd.RunCommand acCmdSaveRecord

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[hefly]

Thank you so much for responding to my inquiry.

My form has emdeded macros.

I tried placing the DoCmd in the events, I get the message:

"...can't find the object 'DoCmd.'
If 'DoCmd' is a new macro or macro group, make sure you have samved it and that you have typed its name correctlly.

I'm still stuck.

hefly

 

[randy700]

Place the code Ken gave you before running the macro.

Private Sub ButtonName_Click()
    DoCmd.RunCommand.acCmdSaveRecord
    [i]your macro call goes here[/i]
End Sub

Randy

 

[hefly]

I'm having trouble with this one:

Private Sub cmdPreviewReport_Click()
    DoCmd.RunCommand.acCmdPrintPreview
End Sub

When I try and run the code, the Macro box pops up, prompting for the macro name. It is not a macro but an event procedure.

 

[hefly]

When I click the command button, I get a compile error:

Argument not optional.

Thanks.

Hefly

 

[KenReay]

Hi

Why have you changed the DoCmd ?

If you create a command button (using the wizard) to run your report, it will generate some VBA code, in the OnClick Event of the command button you have created.

Thacode will include a line like so:

DoCmd.OpenReport ... ext etc etc

Add the line of code I gave you:

DoCmd.RunCommand.acCmdSaveRecord

BEFORE the docmd.OpenReport line

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[hefly]

Thank you KenRay and Randy.
It works.

Hefly