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

  • 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.
    Tuesday, August 11, 2020 3:05 AM

All replies

  • 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"


       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

    Tuesday, August 11, 2020 10:10 AM