Reset combo box to first item

I don't know if this a SharePoint or a MS Access question. I have a MS Access 2010 web database on SharePoint. I'm using a combo box to filter a form. After update  triggers a macro using the SetFilter action. How can I reset the combo box to the first item. Your help is greatly appreciated.
wagebhartAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

aikimarkCommented:
Have you tried setting the ListIndex property of the combobox to zero?
0
Hamed NasrRetired IT ProfessionalCommented:
In Form_Open event procedure::

Private Sub Form_Open(Cancel As Integer)
   Combo1.Value = Combo1.ItemData(0)
End Sub

Open in new window

0
wagebhartAuthor Commented:
I've been unable to figure out how to do this. This is a web database. The bound column property is not available for my combo box. It is only available client side. vba is also only available client side. I think I need to use a macro to set the property but the list index property cannot be set with a macro.
0
Acronis True Image 2019 just released!

Create a reliable backup. Make sure you always have dependable copies of your data so you can restore your entire system or individual files.

PatHartmanCommented:
The web app has significantly less functionality than traditional client/server apps.  In some cases, you can get around the deficiencies by creating a hybrid app.  With a hybrid app, all your data is in Azure and available from anywhere but some or all of the processing part of the app stays as an .accdb and is distributed the way your LAN apps were.  The difference is that the BE is in the cloud.  Be aware, that if you are not hosting Azure yourself, you may have speed issues that a service bureau will not be interested in solving.
0
wagebhartAuthor Commented:
I found a solution. I used the Macro SetFilter action to filter the records on my form using the value of a combo box. I added a command button to clear the filter using the on-click event. I used the SetFilter action and for the Where expression I entered "". I then used the SetProperty action to set the value of the combo box to __(blank, empty field).

The SetProperty must happen or occur before the SetFilter action or it will not work.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
PatHartmanCommented:
Thanks for reporting back with your solution, especially the warning:)
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.