exclamation !

[influent]

I'm going through some code from an inhouse app that my company is running because I need to understand how it works. I understand the following section of code except for the exclamation points. Does anybody know what their purpose is?


'Take the label name, append label type and look for label
str3rdName = Trim(!Label_Type & frm3rdParty.txt3rdlblName & ".QDF")
str3rdPartyFile = Trim(str3rdParty_FilePath & str3rdName)
'Locate the 3rd Party Label in appropriate path
If fso.FileExists(str3rdPartyFile) Then
frmPrinting.Show
frmPrinting.Refresh
'Set the Baytech Port / Com Port and Delay
strPortNo = !Printer_Port
strProd_line = !Production_Line
strPort_Name = !Port_Name
Set_Printer_Port

[Jop]

I think it has something to do with 'collections' or something, I never use(d) them yet, hope I may use them soon, they look cool

[paulw]

! indicates a field within a collection as opposed to the . which indicates a method.

Confusingly, you can't use ! in SQL to indicate fields of a table you have to use . ???

Cheers,

P.

[HeSaidJoe]

they are also used as shortcuts in referencing a field within a recordset

With Rs
.movenext
!myfield = text1
.close
end with