I need CIR.vendor to be distinct. here is the code that does not use distinct. I can't just stick dinstinct row or distinct in there because there is a different index number for each row. This is for a listbox on a form.
SELECT CIR.Vendor, CIR.index
from CIR
ORDER BY CIR.Vendor;
thread702-1609388
I'm trying to lock certain fields in a form based on user login and a table created withh user and security levels.
I think the above thread would work but I am new to VB and Access and I do not have the GetRole() function. I am assuming this is user defined?? Thanks,
Go
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.