I am trying to get Access to enable a field [Review outcome] but ONLY if the numeric value in another field [Review ID] is equal to or greater than 395.
I've tried a few things out using the "Private Sub Form_Current() " coding but to no avail.
Can you help?
Here's the question: At what point is this to happen? Upon form entry? After data entry in the Review ID field? What kind of form is this? Why aren't you referencing form control names instead of column names of a table?