Default value in combobox

[50ld13r]

i have a combo box from a table with id(autonumber) and status(option 1, 2 and 3) as the col names. I want the default value to equal option 1 and when you load the form this default value be displayed in the combobox. I do not want the form to be loaded and set the value again if option 2 and 3 have been selected from a previous session. I have tried something like:

= [tblStatus] in default value field

but the combobox is still blank

 

[KenHigg]

Can get this with a dlookup()?

 

[50ld13r]

sorry you will have to dumb it down a little im new to access. Where do u put the dlookup? in the default valuefield? if its not i dont really want to cycle through all my records - really i want it to work like the default value so when you create a new record its set to option1.

 

[rborob]

Me.combobox = Me.combobox.ItemData(1)