How to write a Default Value in VBA?

[michalgut25]

e.g. I want to set "10" as a default value in to my unbound subform (in column).
How should I write line a code for that?

 

[John Big Booty]

You don't need code to do that.

With your form in design view, go to the Data tab of the properties window, click on the text box, and enter 10 in the Default Value field;

 

[michalgut25]

Thx John, I know about this function in properties, but I think I gave bad example. I have unbound form with unbound subform. See attached Image. Value from field number (form) should be default value in column (subform). VBA Code could be placed in number field (form) after actualization.

 

[John Big Booty]

OK, check out the Default Value property.

 

[John Big Booty]

You might also find this link useful for formulating the correct syntax for referencing subforms, their controls and their properties.

It's a handy link to bookmark

 

[michalgut25]

John how do you past image in to the message?

 

[pr2-eugin]

You have some information on uploading pics in the FAQ section.. But considering your post count you will not ab able to do it.. If you have to upload pics, follow this Sticky thread..