Can Access skip fields conditionally?

[jgreen]

We want the program to realize a field is a certain value and skip succeeding fields if that condition is right. For example, we have a field that is the outcome of a transplant. If the field says "Not Transplanted" we want to go through the succeeding fields about the transplant since they aren't germaine anymore....We've found the GoToControl but don't know how to use it and can't find any code examples....
Thanks.

 

[meo]

skip pattern

Is there a way to do this skip code with out using coding?

 

[giovi2002]

yes in access 2003 right click a control and use conditional formatting.
You can make expressions referring to other fields. If you want to skip set the default record disabled (in the conditional formatting it's the little box) or set your conditions to disable the field.
When using your tab in the form you will notice access automatically skips the disabled fields.