Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2013
    Posts
    99

    Unanswered: Browse to form based on date

    Good Morning hope everyones well

    I need to open a form base on a date within VB. The change over date is based in a text box which is linked to a table. For example

    This is would be within the onopen event

    if currentDate() > me.textbox.value then

    docmd.openform "Form2"

    Else

    Docmd.openform "Form1"

    Any help would be much appricated

    Thank you

  2. #2
    Join Date
    Feb 2013
    Posts
    99

    Resolved

    Not sure why I was having so many problems but it has been resolved

    Dim licenceend As Date

    licenceend = "03/09/2014"


    If Me.DDAYTXT.Value > licenceend Then

    DoCmd.Openform "form2"

    Else

    DoCmd.Openform "form1"

    Thanks

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    so why would you have two forms dependant on a date?
    presumably the two forms are similar in design and content....
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •