message box

[Xenix]

I have a form that prints quotations, before I print or email one I want a message box to appear that lets me type the authorised persons name. I have a field name defined but don't know how to get a box to appear promting for input? or pull down list

anyone help?

Thank you
Mike

 

[jwindon]

Your question is not too clear to me. Please elaborate a little.

What is the authorizing person? Are you wanting to print only quotations that have that person's name on them? It the authorizing person a field that is present on your form?

 

[Xenix]

No Authorised person is the person who would normally sign the quotation that is printed or emails to a customer, So I stored the basic first names in a combo box

now I just need it to pop up with a box after pressing my print or email button so I have the option to select a persons name

Can I do this?

Thank you in advance

 

[jwindon]

I must be missing something here. If you have the authorizing person names in a combo box on your form, why not choose the name on the form before you hit the print button?

If you need to add it to your form, you can do this using the combo box wizard and selecting the table that the names are stored in.

Getting warmer?

 

[Xenix]

Yes this is good, but I just want it in a box before after I press the button for email or print, just for good looks.

 

[jwindon]

So you want the combo box to pop up?

Make a new form and put the combo box on that. Make sure your form is unbound......(not sure what happens when you hit Print) need to let me know that.

Have a command or event on your form to first open this new form....and then move on to the print.

Let's see where that gets you.

 

[Fizzio]

I assume you are printing a report. If your report is based on a query, add the AuthorisedName field (or whatever it is called) into the query and on the criteria, add the line

=Forms![ComboSelectForm]![ComboSelect] where ComboSelectForm and ComboSelect are the form and unbound control jwindon described.

Place this field on your report where you want it to be seen.

Have the print button to open the combo select form then set the afterupdate property of the combo box to open the report in print or preview mode (and close the combo box form if you like)

HTH

 

[Xenix]

I added a combo box on the form before it opens the report

it works great now, thank you guys