Passing Form Field Default Values

This video shows you how to pass form field default values in MS Access.

Here’s a step by step:

1. Create a basic form

This form has a text box called “txtText” and a button which opens a form called “frm2”

1
2
3
4
Private Sub btnOpenF2_Click()

    DoCmd.OpenForm "frm2"

    

End Sub

2. Set the default value property

The above effect is obtained by setting the “default value” property of the textbox:

Questions?

Get all the videos in this Access VBA collection 100% FREE by signing up at http://vbahowto.com/ms-access-tutorial

“Go Fund Me” Page

($5 suggested amount)

(…10% of your gift amount will go to charity)