VBA for Command Button

[noaccessguru]

Hi guys,



I have a Form for users to enter data and then there is a command Button to Print the Report for that record.

How do I write in VBA in the 'On Click' event to 'Save Record and then open Table Tbl_DevList' etc?)
(I need to 'save record first' because one of my calculated fields isnt updating properly and this is solving it)

I know how to do it as a Macro but would rather do it in VBA and everything I try isnt correct


I know this is a simple, easy question for most of you....so TIA

[pbaldy]

I'd probably use this for the report:

http://www.baldyweb.com/wherecondition.htm

the save is often done with

If Me.Dirty Then Me.Dirty = False