Combo Box Default Value

[Guest]

I have a form which is used to enter lines on an invoice with a combo box. I
would like to select a value for these combo boxes on the first line of the
invoice and then have this appear as the default value for for any future
combo boxes. If the user chooses a new value at any point then I need that
value to appear from that point on etc.

Any assistance would be much appreciated.

 

[Allen Browne]

See:
Carry current value of a control to new records
at:
http://www.mvps.org/access/forms/frm0012.htm

 

[Al Camp]

Shannon,
Use the AfterUpdate event of your combo to change it's own DefaultValue.
(ex. cboCustID

Private Sub cboCustID_AfterUpdate()
Me.cboCustID.DefaultValue = "'" & cboCustID & "'"
End Sub

Whenever you override the DefaultValue, that becomes the new
DefaultValue.

 

[Guest]

On the after update event of the combo you can enter the code

Me.ComboName.DefaultValue = Me.ComboName