combo box value

[injanib via AccessMonster.com]

How can I make a selection from a combobox stay the same for nex records
untill I go back and change it? That is with keeping the combobox in the
detail section of the form.

 

[Guest]

You need to bind it to a field in your database.

Put a field in your database to store the selection from your combo, then in
your form, set the Control Source of your combo to that field.

Steve

 

[injanib via AccessMonster.com]

It is already bound to a feild called [Courier] and that is the control
source for the combobox in the form. the options in the combobox are "FedEx",
"UPS", "DHL" and "Others". I use this form to login incoming packages. When I
select FedEx to log in fedex packages I have to expand the combobox and
select FedEx for every package. I want have it so that it stays on FedEx
untill I manually change the selection.

 

[Pieter Wijnen]

Set the Default Value of the ComboBox
ie
Private Sub Combo_AfterUpdate()
Me.Combo.DefaultValue = "='" & Me.Combo.Value & "'"
End Sub

HTH

Pieter

It is already bound to a feild called [Courier] and that is the control
source for the combobox in the form. the options in the combobox are
"FedEx",
"UPS", "DHL" and "Others". I use this form to login incoming packages.
When I
select FedEx to log in fedex packages I have to expand the combobox and
select FedEx for every package. I want have it so that it stays on FedEx
untill I manually change the selection.

You need to bind it to a field in your database.

Put a field in your database to store the selection from your combo, then
in
your form, set the Control Source of your combo to that field.

Steve