Having a field populated when you select a value from a combobox on the form

[Kozbot]

Hello

In my quality control database QC techs will be entering in test results. Each quality control entry they put in will have a product and lot number it is related too.

My question is about making data entry easier for the QC techs. When two jobs are being run at once, the techs may have to alternate between which jobs they enter, meaning a different product and lot number. It would be frustrating for the QC techs to enter in a product code and lot number for every entry they make.

Can the lot number field be automatically populated when the tech selects a product? Basically, if the tech selects product A, can the last lot number value for product A automatically populate the field in the new entry?

Edit: Currently I have the "solution" of making two instances of the entry form with each lot number entered on the different one. This allows the QC Techs to use the CTRL+ ' to populate the last record, allowing them to quickly enter the product code, lot number, and date of the job they are working on.

 

[Galaxiom]

Use the AfterUpdate Event of the Product control to write the return value of a DMax function to the Lot.

(A DMax function reads a table and returns values from a record which has the maximum in a specified field of all the records.)

 

[Kozbot]

Use the AfterUpdate Event of the Product control to write the return value of a DMax function to the Lot.

(A DMax function reads a table and returns values from a record which has the maximum in a specified field of all the records.)

Will this return the maximum value of the lot number. The lot numbers may not be larger or smaller then each other, as they have text.

What I'm looking for is returning the lot number that was entered for THAT product. this value may be higher or lower then the lot number that is being entered for the OTHER product.

 

[Galaxiom]

The DMax can include a condition.

Take a look at the documentation.
http://msdn.microsoft.com/en-us/library/office/aa172181(v=office.11).aspx