Hi i need some help on working with a datacombo..

what i am trying to do is set a default selection in a datacombo. i.e. if my datacombo is bound to a column containing id's like 1,2,3 then i want that id 3 should come as selected by default.

any help on this will be appreciated

If you look at the form in design view and look at your combobox's property window, you can set a default value there.

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Hi
Thanx for replying to my posting

But actually i was looking for a way for dynamically setting the default selection in a datacombo. Found a solution for it. It can be done as follows:

After populating the datacombo, set
datacomboNAME.Text = strDescription

where strDescription is the description field corresponding to the id that we wish to select by default

Thanx anyway

No, that's not how you set a default in code. What you did was to actually assign the textbox a value. It just so happens the value is strDescription.

To set a default with code it's

Me.datacomboNAME.DefaultValue = strDescription

What's the difference?

If you use the .DefaultValue method like I did, then:

You're on the last record, say number 10.
You scroll forward to add a new record.
You start typing in a field.
Your new record, number 11, is created.
Your datacombo gets the default automatically.

OR

You're on the last record, say no. 10.
You scroll forward to add a new record.
You change your mind and scroll back.
Your new record, would have been no. 11, is NOT created.
You still have only 10 records.

If you do it your way.

You're on the last record, say number 10.
You scroll forward to add a new record.
Your datacombo has no default. You literally assign it a value.
You start typing in another field.
Your new record, number 11, is created.

OR

You're on the last record, say no. 10.
You scroll forward to add a new record.
Your datacombo has no default. You literally assign it a value.
You change your mind and scroll back.
Your new record, no. 11, is STILL created, but it only has one field filled out, i.e. the datacombo.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Hi

Thanx for explaining it to me. But I was not able to find the 'defaultValue' property !!