Assigning textbox value through vb

[cbende2]

Hello all,

I'm having trouble assigning a textbox a value that is calculated in vb.



I have little experience in vb, so I'm probably missing something fairly simple.

Private Sub Form1_Load()

Dim Week As Date


Week = DCount("Field1", "Table1", "[Field1] Between #1/1/2014# And #1/8/2014#")
Me.Text2.Value = Week


End Sub

[pbaldy]

For starters, I would declare the variable as Integer, since it's a count that you're putting in it.

[cbende2]

Ok, thanks.

I'm still getting nothing in my textbox.

[pbaldy]

Week might be a reserved word, so try changing that too. Type this in the Immediate window and see what you get:

?DCount("Field1", "Table1", "[Field1] Between #1/1/2014# And #1/8/2014#")

[cbende2]

I get the correct number when I use that in the immediate window.

[pbaldy]

The event looks odd. Put a message box in there and see if it's even running the code. Can you post the db here?

[cbende2]

Sure, here it is:

I'm not sure how to put in a message box to see if it's running the code.


CountingDates.zip

[cbende2]

Got it Paul, the event wasn't even being recognized in the properties of the form.

[pbaldy]

Sounded like it was something like that. Glad you got it sorted.