Date Stamping a Record on a form

[AmyLynnHill]

We are trying to get a field to date stamp when another field is changed from a list box field. We have a macro attached to the list box field using the Setvalue action, the expression is Date (). We are getting an error message :

"the object doesn't contain the Automation object 'this is my table name'"

" you tried to run a Visual Basic procedure to set a property or method for an object. However, the component doesnt make the property or method available for Automation Operations.

Check the components documention for information on the properties and methods it makes available for Automation operation."

Anyone have a clue what this means or how to Date stamp a field in a form when another field is updated?

 

[macca the hacke]

Add/Change the AfterUpdate event on the list box to something like:

if CmdListBox.value <> "" then
txtDateChanged = date()
else
txtdatechanged = ""

Obviously substitute cmbListBox and txtDateChanged for the names of your combo box and text box you have on your form.