Update other fields with specific words after another has been updated

[suzemt]

Basically I am working my through my data base trying to enter as little data manually where possible.

I now want to update one field (what I type into it is irrelevant) but if this field is updated, it means quite a few others become Not Applicable and I would like that to be populated once I updated this one field. After Update is what I am looking for.

I know it is simple (but will mean entering each field name) but it would save me truckloads of time.

Thanks in advance

 

[James Dudden]

There are a few ways you could do this depending on the variations and how many fields you need to update. You could name the controls in such a way that you could then loop through each control and know which to update. Or you could add them all to an array. Or you could simply hardwrite it as follows:

Private Sub AfterUpdate FieldName1
Me!FieldName2 = "N/A or whatever you want"
Me!FieldName3 = "N/A or whatever you want"
Me!FieldName4 = "N/A or whatever you want"
...etc
End Sub

 

[suzemt]

Thanks. It did what I asked, but that turned out not to be what I needed in the end. I'll keep on trying though.