Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Jan 2003
    Location
    Grass Valley, California, USA
    Posts
    88
    Thanks
    0
    Thanked 0 Times in 0 Posts

    2 Bound subforms fail similar record actions (Offi

    I have a main form with a single subform window into which I selectively load one of two subforms, by use of a pair of selection radio-buttons. Neither subform is linked to the main form by any keyed field. Both subforms are bound to underlying tables. I have set the form properties absolutely identical in both subforms (except for the Order By values), and have allowed record selectors to exist for both subforms.

    One subform (Employees) operates exactiy as expected. I can position correctly throughout the row-set, including to 1 beyond the last row being equivalent to asking for a new row. I can delete (behind a Delete command button) any row at which I am positioned, including the last row. The deletes automatically adjust the displayed total row count, and backup one row if it was the last row deleted.

    The other subform (Sites) operates as expected, except for operations on the last row. If I attempt to delete the last row, the delete is ignored. If I position to the last row plus 1, the "forward-arrow" does not grey-out. In fact, I can continue to click on the forward-arrow, with each click generating a new empty record (except for the Autonumber field). I really want this subform to operate in an identical manner to the Employees subform, and I cannot figure out why it is operating differently.

    Hopefully, someone out there can see the errors of my ways....

    -- Jim

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

    Re: 2 Bound subforms fail similar record actions (Offi

    The On Current event procedure of sbfEventSite calls fmtTimes (if opt12Hr is True). This procedure may adjust several of the bound text boxes (to make the time conform to AM/PM format), so the record is "dirtied" immediately, even though the user hasn't done anything yet.

    I haven't investigated a solution. Perhaps all time text boxes should be unbound, with code to set the appropriate fields.

  3. #3
    Star Lounger
    Join Date
    Jan 2003
    Location
    Grass Valley, California, USA
    Posts
    88
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 2 Bound subforms fail similar record actions (

    Hans,

    Once again, my sincere thanks! With your having identified the underlying problem, I'm sure that I can find a solution.

    -- Jim

Posting Permissions

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