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”

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:


Get all the videos in this Access VBA collection 100% FREE by signing up at

Offsite Related Information:

“Go Fund Me” Page

($5 suggested amount)

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

Free! Subscribe To Our YouTube Channel!

Free MS Access VBA Programming Course

Tags: , ,