Add record and print button

[brothertse2008]

i want to have an option for add and print on the same button. At present when you add a record the record vanishes from display. I want to be able to click the button, then for it to add it and print at the same time

how is this done ?

 

[rainman89]

Why is it vanishing? Are you adding a new record right afterwards?


All you would have to do it put the print command after the save command

 

[brothertse2008]

i used the wizard for the initial add button so now im improving it i want to use the same button to print

 

[brothertse2008]

would this be best done using a macro ? if so what options would I use for it ?

 

[rainman89]

Oh so the reason it disappears is because you are using the addrecord to save the previous one...

You can change this to do a save record, print then add new if you wanted....

 

[brothertse2008]

yes, i have the form brought up with a macro in "add" mode. Now, the button to add the record is in place, but once the data is entered into the form, i then click the add button and it saves the record but the data vanishes. I want the button to add the record, and print it when it vanishes

 

[rainman89]

Ok, so are you printing a query or a report?

for a report
docmd.RunCommand acCmdSave
DoCmd.OpenReport "reportName", acNormal
then run your add macro

 

[brothertse2008]

no, the data is on the form and saved to the tables but once it has saved i wasnt it to print is as well

 

[rainman89]

So do you not care about the format of the record? You would be best to create a report that formats the record like you would want it to look, then prints it.

 

[brothertse2008]

i could yes but how would i do this in a macro ?
Also it would be fine for it to print it they way it looks on the form

 

[rainman89]

Im not a wiz at macros, perhaps someone else can help you with one of them