Recent content by Duihou

Thanks, pbaldy. I tried the recordset approach and got it to work very satisfactorily.

Thank you for your reply. I shall read up on opening recordsets. Whilst I can immediately see the benefit of the combobox approach (which provides handy indexing) I have over 14000 account numbers - unsure if this would be practical.

Hello. Not sure where to post, so apologies if this is not the correct location. I'm new to Access but comfortable with Excel and VBA. I'm trying to transform a VBA-heavy form from Excel into an Access database, as multiple accessing is required, as well as data analysis. As I am so new to...