Create a text box that looks up a value in a table

[vanmen]

I've been trying to get dlookup to work without success.

I'm trying to get a title of a class to be inserted depending on the number
of the class.

I tried =DLookup("[Title]","[ Course Listing]",â€[Course #])

and I get "invalid syntax" message. Can anyone help? Thanks.

 

[Steve]

Assuming the text box is named EnterCourseNum and the field in the table is
named CourseNum, you need:

=DLookup("[Title]","[ Course Listing]","[CourseNum] = " & Me!EnterCourseNum)

Steve
(e-mail address removed)

 

[Tom van Stiphout]

On Sat, 22 May 2010 16:42:01 -0700, vanmen

DLookup takes two or three strings. Your last one is not terminated.
It should be ”[Course #]"
Once you do that, it will still not work. That's because the third
string is supposed to be a where-clause, typically:
fieldname = value
For example:
"[Course #] = " & Me.myCourseNoControl

-Tom.
Microsoft Access MVP

 

[Steve]

That's just what I said four and a half hours ago!

Steve

On Sat, 22 May 2010 16:42:01 -0700, vanmen

DLookup takes two or three strings. Your last one is not terminated.
It should be "[Course #]"
Once you do that, it will still not work. That's because the third
string is supposed to be a where-clause, typically:
fieldname = value
For example:
"[Course #] = " & Me.myCourseNoControl

-Tom.
Microsoft Access MVP

I've been trying to get dlookup to work without success.

I'm trying to get a title of a class to be inserted depending on the
number
of the class.

I tried =DLookup("[Title]","[ Course Listing]","[Course #])

and I get "invalid syntax" message. Can anyone help? Thanks.

 

[John... Visio MVP]

You are showing your lack of awareness to the details. You did not submit a
post at 5:30am as you indicate, your post was at 7:52 last night.

Of course, details and facts are not your strong point.

John..

That's just what I said four and a half hours ago!

Steve

On Sat, 22 May 2010 16:42:01 -0700, vanmen

DLookup takes two or three strings. Your last one is not terminated.
It should be "[Course #]"
Once you do that, it will still not work. That's because the third
string is supposed to be a where-clause, typically:
fieldname = value
For example:
"[Course #] = " & Me.myCourseNoControl

-Tom.
Microsoft Access MVP

I've been trying to get dlookup to work without success.

I'm trying to get a title of a class to be inserted depending on the
number
of the class.

I tried =DLookup("[Title]","[ Course Listing]","[Course #])

and I get "invalid syntax" message. Can anyone help? Thanks.

 

[john]

hi! nice to meet you.

That's just what I said four and a half hours ago!

Steve

On Sat, 22 May 2010 16:42:01 -0700, vanmen

DLookup takes two or three strings. Your last one is not terminated.
It should be "[Course #]"
Once you do that, it will still not work. That's because the third
string is supposed to be a where-clause, typically:
fieldname = value
For example:
"[Course #] = " & Me.myCourseNoControl

-Tom.
Microsoft Access MVP

I've been trying to get dlookup to work without success.

I'm trying to get a title of a class to be inserted depending on the
number
of the class.

I tried =DLookup("[Title]","[ Course Listing]","[Course #])

and I get "invalid syntax" message. Can anyone help? Thanks.