2 columns combobox defaultvalue

[Bioman]

Hi!

In a form I have a combobox with 2 columns. The RowSourceType is a list of values. How can I set the defaultvalue of this combobox?

Thanks!

 

[KenHigg]

dLookup()

???
ken

 

[Mile-O]

Use the DefaultValue property.

 

[Bioman]

Yes, I try to use de defaultvalue property but it dosen't work.

My list of values is like this:
All;(no filter);1;Critic;2;Normal

The list is diplayed on 2 columns. When I put "All" in DefaultValue Property, it doesn't work, neither if I put "All;(no filter)"

 

[KenHigg]

Rowsoure: "All";"(no filter)";"1";"Critic";"2";"Normal"

Default Value: "All";"(no filter)"

???
ken

 

[Bioman]

With Default Value: "All";"(no filter)" I get a syntax error message

 

[SforSoftware]

Hi,

with rowsource: All;(no filter);1;Critic;2;Normal
and dependent column = 1 then defaultvalue should be: "All" (not: All)

 

[Bioman]

Thank you for your help. If I put ="All", it work fine...