Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Form control source (A2k)

    I have a form set up (go figure, right? <img src=/S/evilgrin.gif border=0 alt=evilgrin width=15 height=15>), that is basically a backbone for a set of tabs. On one of the tabs, I will have a list box to select a record from the database, and set the focus of the form to that record. My problem that I have run into in the past is that after a record is selected and information is edited, I will get an error "The information has already been changed. Please re-edit the record" when attempting to go to another record. I guess I'm asking for the <font color=red>("correct" or "proper") AND ("fastest")</font color=red> way to use a listbox to set the form's focus when the listbox is on a tab.

    <img src=/S/whisper.gif border=0 alt=whisper width=29 height=17>I think Access is getting to my head, my text in <font color=red>red</font color=red> is composed like a query! <img src=/S/nuts.gif border=0 alt=nuts width=15 height=15>
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What&#39;s more, you deserve to be hacked." -Richard Clarke

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

    Re: Form control source (A2k)

    A tab control is only a container for controls, no more. It doesn't really matter whether a list box is on a tab page or not.

    The easiest way to create a list box to select a record is to turn on Control Wizards (the magic wand button on the Toolbox) before creating a list box. The list box wizard will offer three options. Select the 3rd one, then follow the instructions. I've never had problems with such a list box.

  3. #3
    4 Star Lounger
    Join Date
    Jan 2002
    Location
    Brookings, South Dakota, USA
    Posts
    449
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Form control source (A2k)

    Hi Jeremy,
    I've run into that problem when I've opened a Recordset used to find a record and have "forgotten" to close that recordset...or have "inadvertently" used a dynaset rather than a snapshot. In other words I'm trying to edit a record while that record is present in an editable form somewhere else.
    Just a guess as I don't know how it is you're searching.

    gdr
    <IMG SRC=http://www.wopr.com/w3tuserpics/gdrezek_sig.jpg>
    "Those who dance are considered insane by those who can't hear the music" - George Carlin

  4. #4
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Form control source (A2k)

    Gary - I was using a dynaset <img src=/S/stupidme.gif border=0 alt=stupidme width=30 height=30>. I'll remember that this time. Thank you! <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What&#39;s more, you deserve to be hacked." -Richard Clarke

Posting Permissions

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