Create Multiple Records on One Form

[JHB]

The record is successfully created but my record source navigator at the bottom will not let me go to add a new record. I have to close the form and open it back up if I want to add a new product, lot number, and test results.

Yes - here we have it.
Instead of going to a new record, (which you can't), you select a new "Product" or even the same "Product" in the combo box.
If you want to clear the LotNo control when you click the save button then you need some code for that.

 

[kyoch]

Ok, thanks again JHB. Very much appreciated.

 

[kyoch]

JHB, I've ran into another wall and I need your help again!

Product A has a "Color" QC spec but the TestResult field is a number field. I've created a table that assigns a number to a list of colors. Is it possible to add some code that says if the TestName is "Color", then change TestResult field in the subform to combobox where it displays the colors in the drop down but stores the number? Then for all other tests for Product A the TestResult field should still be a regular textbox.

 

[JHB]

Post your new version of the database.
Could you make some print screen how you would like it to work/ looks like, it would be much appreciated.

 

[kyoch]

I've attached the last database you posted and just added the tblColors to it. I couldn't get a screenshot of what I'm trying to describe so I'm going to explain it the best I can. Here's what I'm looking for...

Select Product A from the ProductName combobox.
The TestNames that appear in the subform are Color, Density, and pH.
I want the TestResult field for Color to be a combobox which displays a text value but stores the number in tblResults. Then density and pH are left as is to enter numerical values.

For example, let's QC Product A again...
Lot number is 1111
I want the user to be able to pick from a list of colors (Brown, Blue, Green, Yellow) from a TestResult combobox next to the Color TestName. Let's say they picked Green.
Then enter a numerical value for density (1.020) and pH (7.50).

The records stored in tblResults should be:
ProductName - LotNo - TestName - TestResult
Product A - 1111 - Color - 3
Product A - 1111 - Density - 1.020
Product A - 1111 - pH - 7.50

Let me know if that makes sense!

 

[JHB]

Sorry - that is not possible to make.