Report not pulling correct record

[jlo33jenn]

I just started using the "Desktop Time and Billing" template in Access. I've entered in some data, but when I go to run the invoice... it only pulls up the 1st record. How do I create it to run a specific record?

[ItsMe]

At the bottom of the form are there buttons to navigate forward and backwards through the Recordset? Maybe there is a field you can enter search criteria in, also.

[June7]

Can't replicate the issue. I created two expense records for same project. Both show in the invoice report.

I think this db is designed for a single invoice per customer per project. I added another project for same customer. The invoice pulls data for only the latest project as billables. Although it does show expenses for the other project in a grand total.

[jlo33jenn]

I was playing around with it more this weekend. I need to have it so when I am on a specific record in form view (let's say the 4th out of 10 created), that when I click a command button, it prints that specific form in a report for me.

I'm thinking there must be something missing in my macro to make this happen. This is what I have so far when I look in the Macro Design:

ACTION: ARGUMENTS:
OpenReport Invoice, Print Preview, , , Normal
RunCommand Print

Any assistance would be appreciated as I don't know much about macros.

[June7]

Need filter criteria passed to the report - WHERE CONDITION.

I don't use macros. In VBA would be like:

DoCmd.OpenReport "Invoice", , , "ID=" & Me.tbxID

However, somehow the invoice report currently opens to specific customer and shows only the latest project for that customer. I haven't figured out how, yet.

NOTE: I deleted the duplicate thread on this same topic.

[jlo33jenn]

Thanks. Still learning the basics of both macros and VBA. Do you have a website or youtube video you could recommend to give me a quick tutorial on VBA's?

[June7]

https://www.accessforums.net/program...ram-53058.html

https://support.office.com/en-us/art...0-DAB7C75CBE0C

In the event property select [Event Procedure] then click the ellipsis (...) to open VBA editor, type code in the procedure. That's one way to open the VBA editor and initiate establish procedure at same time.

There is macro equivalent to the VBA I suggested.