Thanks guys, much appreciated.
Actually I use both: I found that unless I used both Requery and Refresh my combo boxes wouldn't refresh with the proper SQL (which I'm constructing at run-time with the Combo GotFocus event based on all the selections on the form).
The process goes something...
Hi all,
I've got a listbox on a form which is enabled for multiple selection (Multi Select = Extended).
Row Source Type: Table/Query
Row Source: query whose SQL I manipulate in VBA (the idea is to only show the relevant values based on the other selections on the form, namely 5 combo boxes)...