Invalid use of null query

[techkenny1]

Hi
on a form I use the following code:
Me.Date12 = gstrDate12 on a command button

on a second form I use this code, on Load, gstr.Date12 = Me.Date12 so that the data will roll over onto the second form.

How do I write the code when the text field has no data so that the "invalid use of null" does not appear.

Many thanks,

Ken

 

[HarleyQuinn]

Have a look at the Nz() function.

Hope this helps

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[PHV]

Define gstrDate12 as a variant instead of a date.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[gwinn7]

Avoid variants whenever possible!

Gary
gwinn7

 

[PHV]

gwinn7, FYI, only Variant can hold null value in VBA.

 

[gwinn7]

Yes, I know! But why use a variant, when you don't need to?

Its much better programming practice to keep your data types as tight and under control as possible. The Nz option is a far better solution.

I very very rarely have to use variants in my code.

Gary
gwinn7

 

[PHV]

Please, reread carefully the original post.

 

[gwinn7]

I did.

Gary
gwinn7

 

[PHV]

I did
And so what ?