Access 365 - Default Value in Combo Box

Question

Hi All

I am using the Inventory DB Template and I am trying to set a default value in the "Ship Via" Combo Box. I have one entry [Company] in the Shippers table which I want to populate the combo box every time I open the form where a selection is required.

Answer 1

Hi 

A couple of screenshots to clarify

Answer 2

You could look up the ID value in the Shippers table, and put that number in the Default Value property.

Answer 3

Thanks Tom

I have been trying to do that, I am missing something in my in my SQL query. The ID is 5, any help would be appreciated

Thanks

Answer 4

If 5 is appearing in the combobox, you need to adjust the width of the columns in the combobox, setting the width of the ID column to 0, so that space is available for the Company.

Answer 5

Thanks Doug but thats not the problem. Nothing is appearing in the combo box which is the problem. ID 5 is the ID of the row which i want to show in the combo box by default. 

I am pretty sure i need a SELECT query dithe rin the default property or similar