.requery stops working?

[RuralGuy]

It is troubling that the other ListBox reference throws the error that it does. A ListBox has a RowSource that you can Requery so it should work. As a test, I would create a new ListBox from scratch that has the same RowSource as the 1st ListBox in the sequence and then try to Requery it in your button code. You could have some corruption in your class module that needs to be excized. Have you tried a /decompile yet?

 

[RuralGuy]

BTW, do you know the difference between Requery and Refresh?

 

[AccessChap]

Nope, don't really know the difference between the two functions...

 

[RuralGuy]

Refresh simply refreshes the current RecordSet. If records have been added you will not see them. If records have been deleted, they will still show but show as deleted. A Requery starts fresh. It will not show records that have been deleted and it will show any new records. Refresh is used if you have not played with the record count but have changed some of the fields in the current RecordSet. These changes will be reflected with a Refresh but you will not lose your record pointer. A Requery puts you back at the beginning of the RecordSet.

 

[AccessChap]

OK thanks for that

 

[RuralGuy]

Have you tried the /decompile or a new ListBox yet?

 

[AccessChap]

Nope, the refresh meets our needs for the moment so I'm going to leave the code as is thanks

 

[RuralGuy]

OK. Good luck with the rest of the project.