Hello.
I am trying to make a filterable picklist. The picklist needs text info such as artist name, a description, date of entry etc. as well as an image of the artesania.
I have managed to create a picklist of all records using an ADO recordset populating unbound forms, and keeping the form...
My question here is partly a design problem and partly a error problem.
I use a DLookup in the BeforeUpdate event of a form to verify whether the new entry is a valid primary key- ie, unique.
My own warning box pops up and Cancel is executed if the key is not unique.
This allows the user to...
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.