I need to create a button in a form that can open 1 of 6 different forms depending on a value of a field. I am not an Access Expert and do all programming visually, so please explain step by step.

Search Help for Select Case. You will find examples there of how to use this code in your form.