Please help

[Terrence Carroll]

I need to timestamp a field when a user completes an audit in an audit date
field. I have a form in datasheet view with all itmes to be audited on the
form. The trigger for the completion of the audit is when the user selects
"Rates Match" or "Rates do not match" from a combo box. A third category
called PO pending is available in the combo box. When PO pending is selected
I would like the timestamp field to be blank or null. I also need to disable
the audit date field for any record where the user selects "Rates Match" or
"Rates do not Match." Any tips on how to do this would be greatly
appreciated.

Thanks,

Terry Carroll

 

[Gina Whipp]

Terry,

Will something like...

'UNTESTED and CHECK field names
Select Case YourComboBoxName
Case "Rates Match"
Me.AuditDateField.Enabled = False
Case "Rates do not Match"
Me.AuditDateField.Enabled = False
Case "PO pending"
Me.TimeStampField = ""

Case Else
'Do something here
End Select

....work?

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

message I need to timestamp a field when a user completes an audit in an audit date
field. I have a form in datasheet view with all itmes to be audited on the
form. The trigger for the completion of the audit is when the user selects
"Rates Match" or "Rates do not match" from a combo box. A third category
called PO pending is available in the combo box. When PO pending is
selected
I would like the timestamp field to be blank or null. I also need to
disable
the audit date field for any record where the user selects "Rates Match" or
"Rates do not Match." Any tips on how to do this would be greatly
appreciated.

Thanks,

Terry Carroll

 

[Terrence Carroll]

This might work but I am unsure of what event to use to trigger the code. I
am not sure that the "after update" event will work for this. Also I am
concerned about when I import data what the imported records will have as the
date stamp. How can I ensure that any imported data has a value of null or
"" in the audit date field?

Thanks,

Terry

 

[Gina Whipp]

Terry,

I would try the After Update event of the combo box. As for the imported
data... I would set up a form with a button that brings the data in and run
two Update queries on it to *fix* the fields you want fixed. Really, there
is no other way besides fixing each record manually.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

message This might work but I am unsure of what event to use to trigger the code. I
am not sure that the "after update" event will work for this. Also I am
concerned about when I import data what the imported records will have as
the
date stamp. How can I ensure that any imported data has a value of null or
"" in the audit date field?

Thanks,

Terry

 

[Terrence Carroll]

Thanks Gina,

This works like a champ.

 

[Gina Whipp]

You're welcome!

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

message Thanks Gina,

This works like a champ.

 

[De Jager]

I need to timestamp a field when a user completes an audit in an audit date
field. I have a form in datasheet view with all itmes to be audited on
the
form. The trigger for the completion of the audit is when the user
selects
"Rates Match" or "Rates do not match" from a combo box. A third category
called PO pending is available in the combo box. When PO pending is
selected
I would like the timestamp field to be blank or null. I also need to
disable
the audit date field for any record where the user selects "Rates Match"
or
"Rates do not Match." Any tips on how to do this would be greatly
appreciated.

Thanks,

Terry Carroll