How can I assign a value to a declared variable in a form

[Guest]

I need to assign a value from a table to a declared variable in VBA (a
declared variable "Number" takes on a value from table X) It's probably not
hard, but i'm confused about the syntax

 

[Allen Browne]

Use DLookup() to get the value from the field, e.g.:
X = DLookup(...

For help on DLookup(), see:
http://allenbrowne.com/casu-07.html

Note that X must be declared as a Variant, since the DLookup() could return
Null.

 

[Guest]

I did that but I get an "Overflow" error for some reason

 

[Allen Browne]

Did you start the procedure with:
Dim X As Variant

If that doesn't solve it post your procedure.

 

[Guest]

It did work. I changed it from an interger to a double and it works great.
Thank you very much