Unable to make listbox selection

Topic

New Reply

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

Reply | Quote

Replies

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.

Reply | Quote

Hi Hans,
The popform in question is popfrmViews, command button . The popform that works is popfrmTables, command button . 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

Reply | Quote

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.

Reply | Quote

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

Reply | Quote