Linking button on form to report

[hertfordkc]

I've downloaded your example and examined it. I still do not know what you want to change.
Do you want to make the "Quote ID" column disappear?
Do you want to limit the displayed quotes to one "Quote ID"?
???

[robertdudley95]

I've downloaded your example and examined it. I still do not know what you want to change.
Do you want to make the "Quote ID" column disappear?
Do you want to limit the displayed quotes to one "Quote ID"?
???

Sorry! I obviously haven't made it clear, have I?

Basically, I want to get rid of/hide the Quote ID field, and have a field in place where all quotes/invoices have the [...] identifier. Something like this:

Attachment 5098

It should now hopefully be clear to you that the [...] replaces the Quote ID column as the button which prints out the quote. I originally didn't want to use the Quote ID field in the first place anyway - I just used it as a temporary "instant print" button until I could figure out how to put the [...] identifier in its place.

Hope this helps...

[hertfordkc]

Some clarity. Do you want to be able to print one or the other of Mr. Didcot's quotes, or just the first?
Do you insist on doing this without any other button or field?
It may be a day or two before I can get back to you.

[June7]

Presume the subform is in Datasheet view. In Continuous view could have a button.

In a textbox ControlSource: =". . ."

Then in Click event for this textbox:
DoCmd.OpenReport "reportname", , , "QuoteID=" & Me!QuoteID

[robertdudley95]

Presume the subform is in Datasheet view. In Continuous view could have a button.

In a textbox ControlSource: =". . ."

Then in Click event for this textbox:
DoCmd.OpenReport "reportname", , , "QuoteID=" & Me!QuoteID

Oh, wow!

Thank you so much! This wasn't working when I tried it before...

That's this sorted, then. Thank you both for your help...