Someone to help me understand a guide

[carrybag93]

I need help comprehending how to use this:



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

I'm sure it makes sense, but I've only been using Access for a few weeks now, so I need someone more experienced to help me understand it.

What I need to achieve is, when the user finishes filling out their order form, they save it (the record) and then below the 'save' button is a button that generates a receipt, based on the information they just filled out. The receipt should be in form order, and should include all of the information filled in the form. Is this possible? Does the guide linked above solve this problem? If so, could someone please explain how to do that for newbies like me :P

Thanks!

[June7]

Is the receipt a form or report (a report is best if printer is destination). The link is suggesting code that would be executed in a VBA procedure. The criteria you need for the invoice is the invoice number that was just saved. If the object to print is a report, something like (assumes invoice ID is a number type):

DoCmd.OpenReport "report name here", , , "[invoice ID field name]=" & Me.[invoiceIDfieldname]

Review http://office.microsoft.com/en-us/ac...010341717.aspx

[carrybag93]

I'm not sure where to place the code, and what to change it to so it works for me.

[carrybag93]

The link is suggesting code that would be executed in a VBA procedure.

Is this a macro? I looked at the link you left and is that what it's saying? I'm not sure what you mean in the code with [invoice ID field name] and [invoiceIDfieldname] ... do I need to change these to something or leave them like that? Does that code make a whole new report or open an old one? I'm so confused...

[June7]

I use only VBA so the example given is for VBA procedure although macro has equivalent syntax.

Yes, put the real names of your report and fields in place of the generic example.

The code needs to be in an event, such as a command button click.

That link should get you started with writing code. And here is a tutorial you might find helpful http://datapigtechnologies.com/flash...mtoreport.html