How to place a table value into a string variable?

[MCSGraham]

I am trying to place the value of a field in a table into a string variable but it keeps giving an error..this is the code:

Dim strEnroll As String

strEnroll = [Charge!Enroll]

(Charge is my table where Enroll is a field in it.)

Not sure if I have to open the table first either.

thanks a lot!

 

[jebry]

Hi!

Try this:

Dim strEnroll As String

strEnroll = DLookUp([Enroll], [Charge], Put your criteria here)

hth

Jeff Bridgham
bridgham@purdue.edu