showing field dependent on previous field in a form

[char]

you can look at the macro in list view, select form properties and then events on current

[June7]

Ah ha! Had to switch to layout view. I can view the macro and looks good to me. Back in form view I navigate records. The code works. Controls are not visible for Depot locations. This is not working for you?

[char]

It sort of works on 'FBWelding' but only if I type either 'field' or 'depot' in I then have to navigate forward a record then back, it then changes the visibility of fields.
so my second attempt was 'Copy of FBWelding' and that one does not work at all, error message says the control name does not exist.

[June7]

Right, would need same macro in the Location textbox AfterUpdate event. With VBA I would build a procedure that could be called by both events. Might be able to do something similar with macros (macro calling a macro), not sure how.