set combo box to display first row of table source on form entry

[punky]

I need to be able to set listindex of combo box so first row
of its source is always showing when form initially opens.
What is the format of this access statement?

 

[tlbroadbent]

Add the following code to the On Load event of the form.

Me.Combo2 = Me.Combo2.ItemData(0) Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[punky]

HI Throadbent(MIS),

Thanks for the code, but when I used it I got
"Method or Data Member Not Found". It is dieing on
the data member, even tho I used the name of the field
from the combo's source table. Any other method I could
try? I am using Access 97.

 

[tlbroadbent]

You might need to move the code to the On Activate or On Current events of the form instead of On Load.

Reference article at MS KB:

http://support.microsoft.com/support/kb/articles/Q105/5/19.asp

Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[STRYX]

The simplest solution is under properties, set the Default Value to be

[cboSample].[ItemData](0)

'cboSample' being the combo box name and (0) being the first record.

Hope this helps