Change in lookUp should =Date() in another control

[sp00k]

Topic says it all. I have a drop down menu that connected to a table. When you change it, it should update the control beside it(from another table) with the current date.

I've tried a few different things in the expression builder and nothing seems to work(not even updating it with a certain word)

= tablename.ColourDateA = Date()
but even ColourDateA = "Hey" doesn't work

any help would be very great!

 

[rainman89]

is the control beside it a textbox? and is that box bound to the object of date from your table?

 

[namliam]

Use the after update event of your combo to write the date to your form
Yourcontrole = date()

Have fun!

 

[sp00k]

The control beside it is a textbox, which is bound to a date. Called ColourDateA(tried to change the format as well).

So basically the Drop down control is called ColourStatus. On the ColourStatus Event I have the expression ColourDateA = date() for On Change, namliam I have tried After Update, but it also did not work.

 

[rainman89]

is colourdateA the name of the field in your table? you might want to try changing the name of the textbox to something like
txtcolourdateA and then doing

txtcolourdateA=date()

 

[sp00k]

Changed my textbox name to txtcolourdateA, so now my control source is still ColourDateA and the name of my textbox is txtcolourdateA. With the expression in ColourStatus as txtcolourdateA=date() yet nothing works

Is there a way to do this with a macro?

 

[rainman89]

is your form based on a query? and is that query update able?

you can do it with a macro, but its not necessary really

 

[sp00k]

Its not based on a query. Its based on two tables, and one of the tables is solely for a lookup column

 

[namliam]

Try other events to work out the timing of the change... Try on change ...
The event my simply not trigger at the time you hope it too, but using an event is the way to go.