I am trying to fix some VB code and I am a bit confused with the different ways of function calling.

Example:

Call appendClause ("[Run Date]", frm!cboTestNumber, pre, post, STRNG)

or

Call appendCause ("Purpose", frm!cboRunPurpose, pre, post, STRNG)

if you notice, one call has brackets and the second call does not???


what is the difference????

Thanks

ricmar,
In visual basic codes when you have a string/text with a space between
characters for the code to work you need [] before and after the string/text. Like in your example the Run Date doesn't need
a pair of brace when it is Run_Date.
I hope this helps.
john

The brackets are used around a field name. For example, if you're using a DLOOKUP function then it'd look something like this:

strString = DLookUp("[strMyField]", "tblMyTable", "[lngRecNo] = " & _
   Me.txtRecNo)

The first quote is a field name of strMyField located in a table called tblMyTable. The second quote is the name of a table called tblMyTable in the database. The third quote is a field named called lngRecNo in the table called tblMyTable.

Generally for DLookUp, DCount, or in SELECT statements, [] denote a field name.

The other use is when a field name or control element in your form or report has a space in it (a no-no). For example, suppose you put a textbox on a form and called it My Text Box instead of MyTextBox. In VBA code, you'd refer to it like this

If IsNull(Me.[My Text Box]) Then

instead of

If IsNull(Me.MyTextBox) Then


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Thanks guys this helped...