SELECT DISTINCT[Second Table Name].Column Name
FROM[The Name of your second table]
WHERE(([Your Second Table Name].Your Link Column To the
First table)=[FORMS]![The Name Of The Form That
Contains the First Combo Box]![The Name Of your
First Combo Box]))
ORDER BY[Name...
In all that I have read the only way to reset an auto number is to delete all the data from the table, then run "Compact and Repair Database" from the "Tools, Database Utilities" menu.
Why not create a query that pulls the Size information from your main data table to populate the combo box instead of using a seperate field. That way you can still add new values while allowing your users to view the existing data from the Size column.
When you create this query make sure you...
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.