Question, what are commas

[carahorse]

Question, what are the commas in the

DoCmd.OpenForm "TableB", , , stLinkCriteria for? what do they do?

 
[code]
 
thanks, New to VBA
 
just wondered if a guy is supposed to put more in the commas or?

 

[pbaldy]

If you look in VBA help, you'll see that each comma separates an argument. If you skip an optional argument, you still need the comma so Access will know which argument you intend stLinkCriteria to be.

 

[KenHigg]

If you turn on intellisense (sp?) you can see what they are for each command as you type through them...

 

[mdlueck]

You may instead of having a long string of commas in the DoCmd statements use named parameter syntax so that the source code is self documenting what argument was receiving each piece of data. Examples:

DoCmd.OpenForm FormName:=strThisForm, _
               View:=acDesign, _
               WindowMode:=acIcon


'Close window "self"
DoCmd.Close ObjectType:=acForm, _
            ObjectName:=MePointer.Name