Results 1 to 5 of 5
  1. #1
    4 Star Lounger
    Join Date
    Jan 2002
    Location
    Brookings, South Dakota, USA
    Posts
    449
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi All,
    I've got a listbox on a popform (the listbox is located in the FormHeader), which, when opened by itself, will allow me to select a row and in the AfterUpdate event, will go to the record it should. However, when I open that same popform from a command button on another form's subform, I cannot select anything. A little dotted box appears around the first row and that is all....it is not highlighted, not does it ever move to another row. The popform the listbox is on has Data Entry and Allow Additions set to No, Allow Deletions/Edits/Filters set to Yes. This is no different than another popform, very similar design, which does work. I can see no differences between the properties of the 2 forms.
    Where else and what else can I check to fix this?
    Thanks.

    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

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Could you post a stripped down and zipped copy of the database?
    • Make a copy of the database and work with that.
    • Remove all database objects (tables, queries, forms, reports, macros and modules) that are not relevant to the problem.
    • In the remaining table(s), remove most records - leave only the minimum number necessary to demonstrate the problem.
    • Remove or modify data of a confidential nature.
    • Perform a compact and repair (Tools/Database Utilities).
    • Make a zip file containing the database.
    • If you have difficulties getting the zip file reasonably small, save the database in Access 97 format and then zip it. (Of course, this only helps if you're using Access 2000 or later.)
    • Attach the zip file to a reply.

  3. #3
    4 Star Lounger
    Join Date
    Jan 2002
    Location
    Brookings, South Dakota, USA
    Posts
    449
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi Hans,
    The popform in question is popfrmViews, command button <VIEWS>. The popform that works is popfrmTables, command button <Tables>. both are on the sbfrmServerDatabases.
    The original db is in Acc2007 (I know I forgot to note that in the original post -- been out of touch for a while), but I converted this into Acc2003 and the inability to make a selection is still present.
    Thank you.

    gdr
    Attached Files Attached Files
    <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
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    The difference is that you open popfrmViews with acFormReadOnly as DataMode argument for DoCmd.OpenForm. This effectively locks all controls on the form. You don't specify acFormReadOnly in the line that opens popfrmTables.

  5. #5
    4 Star Lounger
    Join Date
    Jan 2002
    Location
    Brookings, South Dakota, USA
    Posts
    449
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks Hans,
    I knew it had to something rather simple I'd overlooked. I didn't even look at how I called the form. I have been out of touch for a while.

    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

Posting Permissions

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