I have an expression in the query under my form to autofill the date but it wont write to the underlying table

[sandraz444]

I have an expression in the query under my form to autofill the date
under a certain condition but it wont write to the underlying table??
The date shows in the form but not the table. Does anyone know a
solution for this?

Thanks!

[sandraz444]

Thank you so much!! I guess it is time to take a class in VB code!
I love Access and I am so glad I found this website where there are so
many nice people willing to help.

Many blessings to you - thanks again!
Bob Quintal wrote:

sa********@aol. com wrote in
news:11******** **************@ k70g2000cwa.goo glegroups.com:

Hi Larry,

I actually started out by making the field default to =Date()
but the problem showed up when I realized all the records I
append to the table (which I have to do daily) automatically
populated with the default date.

I only want the date to populate the field when the record is
closed. Which is why I wrote the query to populate the "Closed
Date" field when the "Status" field has "CLOSED" entered.

But it doesn't write to the table and on requerying it only
shows the current date instead of the date it was actually
closed....

Any other suggestions would be highly appreciated. Thanks
again for taking the time for simple explanations.

Ok, you are going to write a little bit ov Visual Basic code.
I promise you it won't hurt a bit.

First put the "closed date" field on the form. Make sure the
.control Source property is set to the field in the query or
table's name.

Second, in the properties for the "status" field find the "After
Update" box on the events tab. If you already have a macro
there, stop, otherwise click in the box, and pick "Event
Procedure" from the dropdown. You'll see an ellipse(three
periods) button to the right.Click it.

The Visual Basic (VB) editor.will open with the cursor between
two lines of code that the editor has written for you.
The upper line will start "private sub status". The lower line
will be "end sub"

In between those two lines, type:
If me.[status] = "CLOSED" then
me.[Closed Date] = date()
end if

Pretty painless? And now you can add writing Visual Basic
programs to your resumé.
.
Using the After Update event of the "Status" box is so the date
will only get written when you change the status.
--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com