Easy One (for most)....Code for 'Save Record then Open Table'.....

[noaccessguru]

Hi guys,



Not great with writing code (but Im learning.....slowly)

I know this is a real easy one, but I jsut can't get it right!

Can someone please tell me how I basically write the code for it to say: 'SaveRecord THEN Open Table'

Im putting this to an 'On Click' Event for a Command Button.

[June7]

Why do you need to open table? Are you building this db for other users? Users should not work directly with tables and queries, only forms and reports.

[noaccessguru]

Oops I meant open Report!

Basically they are filling in some data then pushing a button to open the report, but its not updating the fields in the report unless I save first.

[June7]

Record is committed to table when close form, move to another record, or run code. So like:

DoCmd.RunCommand acCmdSaveRecord
DoCmd.OpenReport "report name"

[noaccessguru]

Excellent, exactly what I needed! Works a treat.

Thanks June7!

(I will be a star at code one day...)