lookup issue

[krys]

Hello...help!!

I have a table 'PayRate' which has three columns - payrate, date_changed and amount - payrate and date_changed are both primary keys..

In another table which keeps a record of pay called 'paydetails'.. I also have the keys payrate and date_changed... payrate here is a lookup on the PayRate table showing payrate and date_changed... it is bound on payrate..

My problem is in a form where I want to add paydetails... when it comes to selecting the payrate, the correct lookup comes up - for example...
Marking_rate 29/02/04
Marking_rate 15/09/04
What I want to happen is to automatically fill in the 'date_changed' field in my form depending on which row the user selects... I know this has to be done in the code builder.. this is what I currently have in the 'on_change' event:

Me![Rate_Date] = Me.Pay_RateID.Column(1)

All this does is select the first Marking_rate and adds 29/02/04 to the 'date_changed' field... even if I select Marking_rate 15/09/04..

Does anyone have any ideas how I can fix this in the code builder so that I can get the correct date depending on the users selection?

Thank you very much for your help!

Krys

 

[Rich]

You're using the wrong event, it should be the AfterUpdate

 

[krys]

Thank you!! That did work!