Help with default value

[sparker2]

Hello everyone. I need some help! I have an order form with a drop down list that I have added a default value to but it will not update until I manual select the item again from the list. The field is a shipping field that shows the cost in a text box when selected. Why is this and how can I fix it? It will defeat the purpose if I have to select the items manually. Any help or suggestion will be great.

Thanks Shareen

 

[sparker2]

Please help with this if you can!

I need some help! I have an order form with a drop down list that I have added a default value to but it will not update until I manual select the item again from the list. The field is a shipping field that shows the cost in a text box when selected. Why is this and how can I fix it? It will defeat the purpose if I have to select the items manually. Any help or suggestion will be great.

Thanks Shareen

 

[R. Hicks]

Use the following in the "Default" property of the combobox:

=[ComboName].[ItemData](0)

This will have the first choice as the default selected entry.
Change "ComboName" to the name of your combobox.

HTH
RDH

 

[sparker2]

Thanks Ricky, but this did not help. I guess I will have to keep searching for an answer to fix my problem.

Shareen
sparker2@cox.net

 

[wizcow]

Shareen

I'm not really sure what you have going on there, but try doing a requery or a refresh command.

You can go to your 'Records' menu and select 'Refresh'.
If that helps you could also automate the processby adding some code.

Me![ComboBoxName].Requery

Hope that works!
Tom