Strange behaviour

[John Big Booty]

Am I correct in understanding that the problem lay in the implementation of my code rather than the code it self

 

[shutzy]

please look at the upload. i think i am using it in the context it was intended for. i followed the instructions with the search text box's and the query and finished with the listbox that is clickable. to be totally honest i wouldnt know how else to use it. i am new to this and wouldnt dream of trying to change anything, yet.

 

[vbaInet]

Am I correct in understanding that the problem lay in the implementation of my code rather than the code it self

I don't use Access 2010 so Mr. B kindly opened the db and made the changes. He will be the best person to advise on this. I doubt it's your code though.

 

[justiwhi]

John,
Thank you for the code, I am using it and it is fantastic.

Do you know of a way to add a date range to the form/code you posted, and limit what is searched to within these dates? My thought is to have, in addition to the search box, start and end date boxes that a user can use to limit the results based on a date field in all records.

Thank you in advance for any help you might be able to provide.

Nevermind, I found a working solution.

 

[John Big Booty]

You need to add a date picker, and force the code to run once that field has been populated.

 

[John Big Booty]

...that's a discussion that might warrant it's own thread

 

[SyracuseWolvrine]

Thank you to John for the original code, and also to Mr. B for fixing the "lowercase i" issue!