Have a table form for data entry and one of the fields is to enter the serial number. Want to use the validation rule to check a query (need the query cause want it to check only records not annotated as closed for the serial number existence). Do not want to allow the user to enter a serial number that already exist on a record not annotated as closed (which is a checkbox field in the record of the table). Am using the query as the closed field is in the order hdr table and the serial number is in the order line table.
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data.
A Microsoft Access subform is used to show relevant calcul…