K
kealaz
On my form [frmPO_ISSUE] I have a combo box [VENDORNAME] which is populated
with only Vendors that are in my table [tblBUY].
If my table has the following....
part001 vendor001
part002 vendor001
part003 vendor001
part004 vendor002
part005 vendor002
part006 vendor003
where I am going to buy multiple parts from vendor 1 & 2
currently, my combo box looks like this.
vendor001
vendor001
vendor001
vendor002
vendor002
vendor003
How can I have it look for "unique" vendors, such that there are only three
selections.
Vendor001
vendor002
vendor003
Right now, the Row Source info for this combo box is
Row Source Type: Table/Query
Row Source: SELECT tblBUY.VENDORNAME FROM tblBUY;
Can I change the above to accomplish what I described?
Thank you very much for your help with this!!!!
with only Vendors that are in my table [tblBUY].
If my table has the following....
part001 vendor001
part002 vendor001
part003 vendor001
part004 vendor002
part005 vendor002
part006 vendor003
where I am going to buy multiple parts from vendor 1 & 2
currently, my combo box looks like this.
vendor001
vendor001
vendor001
vendor002
vendor002
vendor003
How can I have it look for "unique" vendors, such that there are only three
selections.
Vendor001
vendor002
vendor003
Right now, the Row Source info for this combo box is
Row Source Type: Table/Query
Row Source: SELECT tblBUY.VENDORNAME FROM tblBUY;
Can I change the above to accomplish what I described?
Thank you very much for your help with this!!!!