Help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I have a form today where I would like to add some extra functionality for..

In this form There is a combobox and a datefield called "Date last change
of the combobox".
When the user changes the combobox to a new value I have an after update
event sets the datefield to Date() .

The new functionality I need help with to find a solution...
I want be able to save every change in the combobox and date when it
received its value:
Value1 2001-01-01
Value2 2002-02-02
Value3 2003-03-03

To be able to open a Form/Subform to view this historic data

Thank you in advance

Mattias
 
You need a new table for those historic values. Fields will be the PK value
of the record, the value, and the date it was changed. In your BeforeUpdate
code you can just use an append query to write a new record onto that table
including the PK value of the current record, the value it was changed from
(which you can get from me.ctlName.oldvalue) and the current date/time in
the same way you're doing at the moment.

The subform is then just standard... with the master field the control name
of the pk field, and the child field the name of the key field on the new
table.
 
Back
Top