B burrina Registered User. Local time Today, 00:52 Joined May 10, 2014 Messages 972 Feb 25, 2015 #1 Me.txtversion = "Ver:" & " " & DLookup("[txtVersionMajor] & " - " & [txtVersionMinor] & " - " & [txtVersionRevision]", "tblVersionInfo") Click to expand... What's wrong with my syntax ? It's the "-" part that is the problem. Last edited: Feb 25, 2015
Me.txtversion = "Ver:" & " " & DLookup("[txtVersionMajor] & " - " & [txtVersionMinor] & " - " & [txtVersionRevision]", "tblVersionInfo") Click to expand... What's wrong with my syntax ? It's the "-" part that is the problem.
P plog Banishment Pending Local time Today, 00:52 Joined May 11, 2011 Messages 12,004 Feb 25, 2015 #2 This is how Dlookup works: Dlookup([FieldInTable], TableName) Does this: [txtVersionMajor] & " - " & [txtVersionMinor] & " - " & [txtVersionRevision] resolve to a field in tblVersionInfo?
This is how Dlookup works: Dlookup([FieldInTable], TableName) Does this: [txtVersionMajor] & " - " & [txtVersionMinor] & " - " & [txtVersionRevision] resolve to a field in tblVersionInfo?
B burrina Registered User. Local time Today, 00:52 Joined May 10, 2014 Messages 972 Feb 25, 2015 #3 NO. It works without the added "-" part The table is tblVersionInfo Last edited: Feb 25, 2015
B burrina Registered User. Local time Today, 00:52 Joined May 10, 2014 Messages 972 Feb 25, 2015 #4 Me.txtversion = "Ver: " & DLookup("[txtVersionMajor] & ""-"" & [txtVersionMinor] & ""-"" & [txtVersionRevision]", "tblVersionInfo") This is what I wanted and needed. Just took a while to figure it out.
Me.txtversion = "Ver: " & DLookup("[txtVersionMajor] & ""-"" & [txtVersionMinor] & ""-"" & [txtVersionRevision]", "tblVersionInfo") This is what I wanted and needed. Just took a while to figure it out.
