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

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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Timmy" <(E-Mail Removed)> wrote in message
news:B68E55E5-601D-4C29-9593-(E-Mail Removed)...
>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

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

"Allen Browne" wrote:

> 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.
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "Timmy" <(E-Mail Removed)> wrote in message
> news:B68E55E5-601D-4C29-9593-(E-Mail Removed)...
> >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
>
>

Did you start the procedure with:
Dim X As Variant

If that doesn't solve it post your procedure.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Timmy" <(E-Mail Removed)> wrote in message
news:01F30955-4136-4977-9845-(E-Mail Removed)...
>I did that but I get an "Overflow" error for some reason
>
> "Allen Browne" wrote:
>
>> 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.
>>
>> "Timmy" <(E-Mail Removed)> wrote in message
>> news:B68E55E5-601D-4C29-9593-(E-Mail Removed)...
>> >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

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

"Allen Browne" wrote:

> Did you start the procedure with:
> Dim X As Variant
>
> If that doesn't solve it post your procedure.
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "Timmy" <(E-Mail Removed)> wrote in message
> news:01F30955-4136-4977-9845-(E-Mail Removed)...
> >I did that but I get an "Overflow" error for some reason
> >
> > "Allen Browne" wrote:
> >
> >> 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.
> >>
> >> "Timmy" <(E-Mail Removed)> wrote in message
> >> news:B68E55E5-601D-4C29-9593-(E-Mail Removed)...
> >> >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
>
>