Creating a yes or no combo box that puts the selected yes into another form

Question

Im creating a database for my mothers accounting business and im trying to create a yes and no (completed / not completed) so that when yes is selected that customer and its data goes to one form, and when no is selected it goes into another form. There are times she has to extend tax returns and i would like to have a warning for when its getting closer to its date or goes into a different form like the yes and no selections. Any help would be greatly appreciated.

Answer 1

When you say "go to", you mean open?  If so, then you simply need to use an if statement and open the proper form.

If Me.CheckboxName = True Then

   DoCmd.OpenForm "Form1Name"

Else

   DoCmd.OpenForm "Form2Name"

End If

---

Daniel Pineault, 2010-2019 Microsoft MVP
Professional Support: http://www.cardaconsultants.com
MS Access Tips and Code Samples: http://www.devhut.net