Multiple DLookup Syntax (1 Viewer)

B

burrina

Registered User.

Local time

Today, 09:56

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

P

plog

Banishment Pending

Local time

Today, 09:56

Joined

May 11, 2011

Messages

11,638

• Feb 25, 2015

• #2

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, 09:56

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, 09:56

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.