Search results

Thank you so much - it's amazing how such a simple problem can cause so much grief. specially when I find out the syntax is quite simple! Thanks again

Wow - works! you're a genius. However, only shows first field, I need it to display multiple fields like a table, how can I tweak it to do this? Cheers

I think I have found the problem, when I am programming 'listbox1' recordsource is not an available. listbox1.recordsource = myRS the above is not recognised as valid syntax. Do I need to go in to Tools-References and add something for this to work? Getting there, eternally grateful! Regards...

First of all i'm a novice, so take it easy on me! I have an access 2000 database with multiple tables and forms. within one of my forms I wish to populate a listbox (listbox1) with values from a recordset (myRS) that I have created from a SQL query. Function PopList() Dim dbs As Database...

I am using the lostfocus event to validate unbound text boxes on a form. The first one (Text121_LostFocus) works perfectly, then the second lostfocus event (Text123_LostFocus) works initially then stops reacting for no apparent reason. If I copy the code and repaste it in it works again...