Results 1 to 3 of 3
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Synchronising Two Forms Using a Class Event (2003)

    If, on the startup form of the attached mdb, you select October 3, 2005 on the calendar and click the "Production Readings" button, the subform that opens shows all the available dates, I thought using
    <font color=448800> Me.Recordset.FindFirst "[giorno] = #" & Format(varReadName, "mm/dd/yyyy") & "#" </font color=448800>
    in the Private Sub frmPrev_NewDay(varReadName As Variant) would synchronise the subform date display with the calendar but to no avail.
    What could be wrong with the above code?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Synchronising Two Forms Using a Class Event (2003)

    FindFirst does what it says, it finds a record, it doesn't filter. You can pass a WhereCondition argument in DoCmd.OpenForm to filter the form (it's not a subform since it is opened separately).

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Synchronising Two Forms Using a Class Event (2003)

    Thank you Hans.

Posting Permissions

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