Full Version: Combo Box Default To First In List
UtterAccess Forums > Microsoft® Access > Access Forms
jasco13
I want to be able to have the combo box on a form default to the first value in the list on form load. The combo box is unbound and I'm using it to select the record to be viewed in the form. I am using a select query statement for the row source.
tried setting default to: dfirst([Combo1],[Combo1]) but that didn't do anything.
Any suggestions.
Alan_G
Hi
Try setting the Default Value property to
CODE
=[Combo1].[ItemData](0)
jasco13
That did it.
Thanks,
Matt
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.