Field Defaults to Next Record

  • Thread starter Thread starter Nate
  • Start date Start date
N

Nate

I created a data entry form and I would like 1 of the fields on the form that
is linked to a subform to automatically move to the next record after a date
is entered. Is there a simple way to do this?
 
I created a data entry form and I would like 1 of the fields on the form that
is linked to a subform to automatically move to the next record after a date
is entered. Is there a simple way to do this?
Click to expand...

Yes. Use code like the following in the AfterUpdate event of the textbox.
Assuming that the textbox is named MyTextBox the code would be

Private Sub MyTextBox_AfterUpdate()
Me!MyTextBox.DefaultValue = """" & Me!MyTextBox & """"
End Sub

The four quotemarks before and after get translated to one " each, making the
DefaultValue property a string constant as is required.
 
Back
Top