I have Trade Show database will use message boxes in lieu of Colors. My next question on this DB is?

Hi Everyone,

Please review my Access database now that i have re-done.  I am trying to clear out the Quantity field after the "Order Complete"message Box appears.  What code do i need here to do this?  I tried using Me.Quantity = "", but this is not clearing out the field.  After a person completes one order, I want the Quantity field to become blank so another order for a new quantity is needed for another product for the same vendor or a new vendor.

Any help with this VBA code is very appreciated.

jjc9809
TradeShow-NEW-.accdb
jjc9809Asked:
Who is Participating?
 
IrogSintaCommented:
It seems to work fine when I add it here:
   
    [ProductOrders subform].Requery
    Product.Requery
    Me.Quantity = ""
    Beep

Open in new window

0
 
IrogSintaCommented:
Also, you should set your NavigationButtons and RecordSelectors properties to NO to tidy up your form a bit.
0
 
jjc9809Author Commented:
IrogSinta,

Are you speaking about my event buttons?  What property do I set to "no"?
What record selectors properties are you taking about?  I need more specific information here.

Also, Thank you for you help on the other post.  Yes this works for me too.

After answering these questions, I will score you 500 with an "A" for excellent.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
IrogSintaCommented:
Here you go.  Adjust these properties are for your main form:property sheet
0
 
jjc9809Author Commented:
IrogSinta,

What does this do to the form to tidy it up?

jjc9809
0
 
IrogSintaCommented:
These are unnecessary with how your form is set up.  tidy
0
 
jjc9809Author Commented:
Thanks, IrogSinta,

 I was wondering the other day how to get rid of those.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.