This sounds like one of those situations where you many need to dynamically
build the sql statement using VBA code that populates the Doc Number combo
box.

Here is a link that might help:
http://msdn.microsoft.com/en-us/library/dd627355.aspx

-----
HTH
Mr. B
http://www.askdoctoraccess.com/
Doctor Access Downloads Page:
http://www.askdoctoraccess.com/DownloadPage.htm


"Marc T" wrote:

Hi again,

I have a set of three cascading combo boxes for the following;

Supplier Code, Doc Number, Revision

all is working great, but what I'd like to do is allow the Doc Number combo
to show data for all suppliers if the Supplier Code combo is left empty. At
the moment it shows as a blank if no supplier is selected.

Any help would be great!
Marc