I am trying to design a page that will allow my office to input Quality Control Data in a laboratory. I am using UD 4, ASP and and Access database. I offer the user a drop-down menu that populates based on the database; this allows them to select a "lot number". The "lot number" is attached to an expiration date in the database. The problem is that when they select the lot number, it does not change the expiration date (it keeps the one that the page loaded with),

How do I get these two fields to be linked together, I only need this to populate the fileds, then on "submit" it dumps all the info into a separate database.

Any help would be appreciated.

Bob