Solved How to sort a combobox using VBA

[AlliCarr]

However as people have suggested using a query on the system table or creating a reports table is probably a better approach.

I have now managed to get the SQL working and it works perfectly! Something as simple as a typo was preventing it from working.

Thanks all for your help

 

[Mike Krailo]

I have now managed to get the SQL working and it works perfectly! Something as simple as a typo was preventing it from working.

Thanks all for your help

What was the typo, we're always interested in the exact cause of the problem.

 

[AlliCarr]

What was the typo, we're always interested in the exact cause of the problem.

I had added an extra ‘y’ to MSysObjects so it read MySysObjects and I just didn’t see it the first time I tried it!