SET NULL VALUE WHEN OPEN A FORM

Question

SET NULL VALUE WHEN OPEN A FORM

Anonymous

Hello everyone! With decorations purpose, I'm wondering how to set value on text boxes into null at first time open the form instead of viewing all the data on text boxes

I've tried:

Private Sub Form_Load()

DoCmd.GoToRecord , "", acNewRec

End Sub

... and it worked but I thought it wasn't possible when tapping Next Record button. Could anyone give me some right solution, please?

Thank you!

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

0 additional answers

Answer 1

Hi Thắng, I'm an independent adviser and can help.

If you want to open a form to a new, blank record, you have a few options. If you are opening the form from code, you can set the Edit mode to Add instead of Edit. This can be done in either VBA or a macro. If you always want the form to be used to only enter new records, you can set the Data Entry property of the form to Yes. You could use your method to go to a new record upon Load as well.

Share via

SET NULL VALUE WHEN OPEN A FORM

0 additional answers