afterUpdate

  • Thread starter Thread starter richard
  • Start date Start date
R

richard

I have an afterUpdate event procedure that makes certain
fields visible/invisible when certain selections are made.
However, I would like to have a default selection when the
next record is opened. Right now, whatever fields are
visible in record one are visible in record 2,3... Can I
set a default selection in a combo box that will only
appear for a new record that has no selection? thanks
 
In the form's Current event, check to see if you're at a new record and set
the items as desired.

Example:
If Me.NewRecord Then
'set the visible properties here
End If

You could also change the If statement to check for no selection in the
combobox

If IsNull(Me.cboMyCombo) Then
 
Back
Top