typeing in a Form and automatically writing to a Table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TheNovice - 05 Jul 2007 21:38 GMT

Good day all,

I have a question that is puzzling me and need Help.

I have a form that I am using to track workorders, as I enter the work
order, I have it designed to send an e-mail. the problem is that when I type
in the form it doesn't automatically write to the table.

the Query that is triggered once the Button is selected, cannot ID the added
fields until after the fact.

Can someone please shed some light?

Signature

-The Novice
Learn Today, Teach Tomorrow

Great Success is ones ability to ask for Help.

Reply to this Message

Bob Quintal - 05 Jul 2007 21:01 GMT

> Good day all,
>
[quoted text clipped - 9 lines]
>
> Can someone please shed some light?

I think what you want to do is trigger the email once you have
finished entering the workorder. One way to do that is have the
button save the record before it calls the query to send the
email. In order to save the workorder just put the following
statement in the button's on click event, before it runs the
emailing code.

me.dirty = false
is all it takes.

Signature

Bob Quintal

PA is y I've altered my email address.

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

Reply to this Message

Carl Rapson - 05 Jul 2007 22:04 GMT

> Good day all,
>
[quoted text clipped - 10 lines]
>
> Can someone please shed some light?

When you are filling in the controls on a form, the underlying database
object isn't updated until you leave the record for some reason - closing
the form, for example, or starting another record. You can simulate such an
action by executing the statement

Me.Dirty = False

in the Click event of the button (before your query).

Carl Rapson

Reply to this Message