Replies

I can’t thank you enough!!!

It was text and that worked well. Thank you.
I didn’t realize that it was going to automatically print it out though. Unless there’s another way around it, I’ve put together a macro to open it in print preview. Will you please tell me how to add that into the module. The macro name is mViewQuote.

I tried this but it didn’t work:

Private Sub cmdViewQuote_Click()

DoCmd.RunMacro “mViewQuote”, acNormal, , “QuoteGroup = ‘” & Forms!frmProdSelect_QuoteManager![QuoteGroup] & “‘”

End Sub

I’m afraid I’ve made a mess of this. I’ve made several format errors that if I fix now will require adjusting a lot of queries and links on forms.

The primary key for the form is Quote Group while the primary key on the report has no space, QuoteGroup. I’ll correct it if need be but first I would like to see if that is the only thing that I have wrong.

Private Sub cmdViewQuote_Click()

DoCmd.OpenReport “rptQuote”, acNormal, , “Quote Group = ” & Forms!frmProdSelect_QuoteManager!QuoteGroup

End Sub

Thank you Hans.

I can rework the form if I need to but I want to double check…Do I need to add a button to the form? It is currently set up as a datasheet? I was hoping to run the macro anytime the text in the combo box says “Accept.”

Thank you Hans!

thank you

This is a big help. Thanks!

We will print them one at a time so that this will work because the terms don’t look right in the middle of the page.

These are the fields that I want at the bottom of the page:

TERMS & CONDITIONS
PAYMENT TERMS
PRICE PROGRAM
FREIGHT TERMS
LEAD TIMES

I’ve worked with the codes a little bit but usually just by pasting them in. I clicked on the Page Footer and then clicked on Code. Was that correct or do I need to go to the properties and then create an event?

Also, do I repeat the code for each text (memo) field?

me.txtTERMS & CONDITIONS.visible =true
else
me.txtTERMS & CONDITIONS.visible=false
else
me.txtPAYMENT TERMS.visible =true
else
me.txtPAYMENT TERMS.visible=false

and so on…

That worked great – thanks!

Thank you for your reply. Yes, it is a report. I’ve clicked in the field and set the property to “Can Grow” = yes but it still isn’t growing when there is more text in the box. I may have the language wrong, is the “control” that you are referring to the same as the field or text box?

This worked well for my product fields but the text boxes with the terms are not growing. Does it have to be a certain type of form. I would like the default view for the terms to be a single form but it won’t seem to grow.

Ah ha! Perfect. Thanks.

THANK YOU!

THANK YOU, it’s back. It kind of looks ghostly; the icon color looks faded. Is that okay?