Discussion Locked

Listbox problems in Access 2K

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a form in an Access97 mdb that uses a list box to open a second form to display the details of the record selected in the listbox by using a RecordsetClone and the FindFirst method.
I tried to do the same thing in Access2K and it bombs. Theproject is a checking account. The main window shows the account info, the user can select a check number from the list box to bring up the detail on that check. It appears that there is no FindFirst method in the Recordset object anymore. Any clues out there?

3 replies

by patskyh

There are many differences between DAO and ADO and this is one of them. You can avoid using ADO at all. Base the form on a query that includes the data that will need to be displayed. The selection criteria will be supplied dynamically as the form opens. Use the WhereCondition parameter of the OpenForm Method to supply the key information to bring up the correct record in the detail form.

by cswearingen

Thanks for your response. However, this is not what I wanted to accomplish at all.
I posted the question to a MS Access newsgroup and got the response that worked there. I was told that I had to manually add a reference to the DAO 3.6 object library and move it up in priority above the ADO reference. After that my code worked exactly like I wanted it to (I don't need any of the advantages of ADO in this project).

This discussion is closed to new replies.