Combine 2 collumns in 1 text field

[xuanb]

Hi,
I want to query 2 collumns and display the result in one text field. Here are my 2 Dlookups that I want to combine into something like "101 Access Forms". Thank you!

Me.ClassID = DLookup("[ClassID]", "tblClasses", "[ClassID] = 101&quot
Me.ClassName = DLookup("[ClassName]", "tblClasses", "[ClassID] = 101&quot

 

[luceze]

Wouldn't this work:
me.YourField=me.classID & " " & me.ClassName

HTH,
Eric

 

[xuanb]

Yes! With a little modification...

Me.myfield = DLookup("[ClassID]", "tblClasses", "[ClassID] = 101&quot
Me.myfield = Me.myfield & " " & DLookup("[ClassName]", "tblClasses", "[ClassID] = 101&quot

Thank you for your help!
Xuan