Hit Save on form and write date to Query

[hardrock]

Hey all, I have a form that is bound to a table called "mytable"

I have a second table called "lastsent", In here i have two columns PersonName and SentLast.

The form contains a combo box with all the employee names and when a name is chosen from the dropdown, the after update runs a query that simply filters the employee name and its associated SentLast date.

I have manually entered the SentLast dates for my employees in the table in short date format.

When an employee is chosen from the combo dropdown, a textbox on the form states "The schedule was last sent on..... " then i have a dlookup that looks up the date last sent. All this works ok!

Now heres the problem.

When i hit the save button on the form, I want to know the simplest way to write the current date into SentLast for the current filtered employee.

Thankyou for any suggestions!

 

[rainman89]

me.txtboxname = date()

 

[hardrock]

Hi rainman, i do have an invisible text box on my form with its default value = date().

When i hit the save button on the form, I want to write the current date into column SentLast for the current filtered employee in the query.

I am guessing i need to use Insert into table or a update query to do this?? any ideas?

 

[rainman89]

you would do
me.sentlast = me.hiddentextboxname