Link to home
Start Free TrialLog in
Avatar of jjc9809
jjc9809

asked on

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
ASKER CERTIFIED SOLUTION
Avatar of IrogSinta
IrogSinta
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Also, you should set your NavigationButtons and RecordSelectors properties to NO to tidy up your form a bit.
Avatar of jjc9809
jjc9809

ASKER

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.
Here you go.  Adjust these properties are for your main form:User generated image
Avatar of jjc9809

ASKER

IrogSinta,

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

jjc9809
These are unnecessary with how your form is set up.  User generated image
Avatar of jjc9809

ASKER

Thanks, IrogSinta,

 I was wondering the other day how to get rid of those.