How do I set default values for a field in a subform in VBA?

[thrainpa]

These subforms are driving me batty, My subform pulls information specific to an Account Number defined in:

[SubFormName].Form.FilterOn = False
[SubFormName].Form.Filter = "[Account Number] = " & AccountNumber & ""
[SubFormName].Form.FilterOn = True
[SubFormName].Form.Refresh

The filter works perfect and I can add new records, BUT the Account Number field in the subform stays blank unless filled in manually.

How can I set this field to automatically fill in with the AccountNumber variable?

 

[odin1701]

ControlName.Value = AccountNumber

Preface ControlName with the Form, SubForm, etc. notation. Here is a handy reference:

http://access.mvps.org/access/forms/frm0031.htm

 

[wiklendt]

have you set the child and master properties correctly? your foreign key should then fill in the subform automatically without the need for extra coding.