Before we can go into detail we need to know a couple of things.
Is it FieldA or Field A (with the space)?
If Field A (with the space) I assume it's also Field B and Field C, with spaces. Is that correct?
Field names shouldn't have spaces in them, but if they do, you have to let the Access Gnomes know that the space is connecting two parts of the name, and in VBA code, you do that by enclosing the name in Square Brackets, such as:
Me.[Field A].SetFocus
And just to be clear...if Status = "Closed", Fields A, B and C are required, but not if Status = "Open"...is that correct?
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007