How To remove a defaulted message in access database

[hursan1710]

hi, I am using the attached generic access database, while it does what i want there is one step i want to take off, once an order is created the user has to specify the shipping information and pick a "ship via".. from the drop down list, if one is not selected the system will generating a message asking to select one, how can i remove or put a default entry such as FedEx so the user does not have to pick a "ship via" every time an order is created. i cant upload the test database to this post but bellow you will find the link to my Google Drive share file.

https://drive.google.com/file/d/0B0e...ew?usp=sharing

thanks in advance...

[ranman256]

set the DEFAULT VALUE of the combo box= 'FexEx'

[hursan1710]

i tried, but will not work, i can set the default for the other tap Payment type and date.

[hursan1710]

i can set a Ship Date to Default=Date() but will not work for the Ship Via.

[Homegrownandy]

Go into design view. Right click the button that makes it happen and click view code. Paste the code here.

[hursan1710]

Go into design view. Right click the button that makes it happen and click view code. Paste the code here.

Hi,

There is no code, the Control Source is an Expresion builder, please see screenshot attached.

[Homegrownandy]

Hey,

You've shows the properties for the combo box. But if I'm correct, this will happen after you press a button? Its the button that the code will be attached to.

[hursan1710]

Hey,

You've shows the properties for the combo box. But if I'm correct, this will happen after you press a button? Its the button that the code will be attached to.

Hi, I am sorry, those are the properties of the Combo Box, i apologizes, i misread the message, when i press Invoice Order, an error is generated asking the user to select "Ship Via", that button does not have a code but a Macro, here is the screenshot.

if too small, here is a link to download the screenshot

https://drive.google.com/file/d/0B0e...ew?usp=sharing

[Homegrownandy]

Sorry for the double post, just wanted to make sure you've seen this. It will be on the "event" tab of whatever is making it happen.. If it happens after you press a button, it will be on the event tab of the button.

[Homegrownandy]

I cant see anything obvious there, If you can post your database here without any sensitive information ill take a look.

[hursan1710]

hey,

this link will take you to my sharebale database, there is not sensitive information
https://drive.google.com/file/d/0B0e...ew?usp=sharing

to get to the error, open the database, click ID order 8 under Active ORders, if you click Invoice order you will get the error.

thanks in advance

[aytee111]

I can't open your database (work server), but to set a combobox value:

After the order has been created, find the right event (AfterUpdate?) and set this in an Event Procedure: Me!shipviacomboboxname = "Ship Via" - that is presuming that it is the first column in the Row Source.

[Homegrownandy]

I cant actually see it on there. I cant access developer tab or design view. I cant even see how its secured. :/