assign data to a combo box that is attached to a table (1 Viewer)

[haljason]

on the form_load event i'm trying to assign
a default value to the combo box that is attached to a table. When i do the following code

me.comboname.value = "default" it does not assign the value "default"

If the combo box is not attached to a table it assigns the value "default" to the combo box.

What is the problem?

 

[cargobay 69]

Why not just use the combo box's default value property instead?

Darrin@CB69

 

[haljason]

i used the default property but it doesn't display.

The purpose is to show a value at form load
so that the user doesn't have to select it from the list each time

 

[BLeslie88]

I have had this prob too...

I use default value and item doesn't value doesn't display on form load... any reason why... any ideas...?

 

[BLeslie88]

Found answer...

So, buddy 3 years later here is your answer, maybe the 'pro's' assume we should know this...

lol...

Anyhow. Assign bound column to 1 or higher, sometimes assigning default value with 0 as bound column, it won't show.

Worked for me.

Thanks...

 

[Robert88]

Hi haljason,

You could always try;

Private Sub Form_Load()
       
    Forms!frmName!CboField.DefaultValue = """D"""
   
End Sub

A little late!!!!!

Robert88