Default Value in Drop Down Combo Box

[Todd D. Levy]

I have a number of Drop Down Combo Boxes where users select a country;
99% of the time the selection will be "United States".

I want to use VBA code in the New Record Event to populate this field
with "United States" as the default value, but still allow the users to
select another value (country) on those rare occasions where it applies.

I just want to make sure that this code will not cause any conflicts
with the normal functionality of the Combo Box.

[Mike Storr]

The combobox has a property called Default Value. Why not set it there
instead of using code?

Mike Storr
www.veraccess.com
"Todd D. Levy" <us************ **@spamex.com> wrote in message
news:MP******** *************** *@nyc.news.spea keasy.net...

I have a number of Drop Down Combo Boxes where users select a country;
99% of the time the selection will be "United States".

I want to use VBA code in the New Record Event to populate this field
with "United States" as the default value, but still allow the users to
select another value (country) on those rare occasions where it applies.

I just want to make sure that this code will not cause any conflicts
with the normal functionality of the Combo Box.

[Todd D. Levy]

Mike,

The reason I don't use this method is that it apparently only works when
the form (that the combo box in question in on) is opened directly.

If it is opened (for instance) via a VBA coded button on another form
the default value is not picked up.

I have tried setting the default value in properties at the form level
as well as for the field at the table level without success.

Unfortunately the code I am using is not working properly either:

In the On Current event I have the following

If Me.NewRecord Then
Me.ComboBox = "XYZ"
End If

What am I doing wrong?

Todd D. Levy

In article <s_************ *******@news20. bellglobal.com> ,
no****@somewher e.con says...

The combobox has a property called Default Value. Why not set it there
instead of using code?

Mike Storr
www.veraccess.com

[Mike Storr]

On Sat, 31 Jan 2004 14:07:13 -0500, Todd D. Levy wrote:

Mike,

The reason I don't use this method is that it apparently only works when
the form (that the combo box in question in on) is opened directly.

If it is opened (for instance) via a VBA coded button on another form
the default value is not picked up.

I have tried setting the default value in properties at the form level
as well as for the field at the table level without success.

Unfortunately the code I am using is not working properly either:

In the On Current event I have the following

If Me.NewRecord Then
Me.ComboBox = "XYZ"
End If

What am I doing wrong?

Todd D. Levy

In article <s_************ *******@news20. bellglobal.com> ,
no****@somewher e.con says...

ComboBox is a reserved word, so if that is the name of your control in
question, you may experience a number of problems. If it is, change it's
name and try again, if it's not and you are using the proper control name,
then I'm not sure what's going on. The Default Value property and your code
should accomplish the same thing. Except that using your code, if the focus
leaves your form and comes back, the combobox value may change when you
don't want it to.

--
Mike Storr
veraccess.com