Results 1 to 2 of 2

Thread: Lost focus

  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Utah, USA
    Posts
    120
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have an Access database that was created in Office 2000, converted to Office 2003 and now 2007. On the main form I have a field where the user can input a date. This date is used in four other tables to filter data. Here is the code behind the date field:

    Private Sub LAST_PFA_DATE_AfterUpdate()
    On Error GoTo LAST_PFA_DATE_Change_Err

    DoCmd.OpenForm "PFA Alerts"
    DoCmd.OpenForm "PFA Full Alerts"
    DoCmd.OpenForm "PFA FIO Alerts"
    DoCmd.OpenForm "PFA Open"

    LAST_PFA_DATE_Change_Exit:
    Exit Sub

    LAST_PFA_DATE_Change_Err:
    MsgBox Error$
    Resume LAST_PFA_DATE_Change_Exit

    End Sub

    For some reason when a date is entered only PFA Alerts opens and I get a window asking for the date again, when this date is re-entered I get the other three tables. Can anyone explain what's happening?

    Thanks.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Do you mean that you have converted to the .accdb database format? Access 2007 can work with the Access 2000 or Access 2002/2003 .mdb format without conversion.

Posting Permissions

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