Autofill text box on form B with contents of datasheet field on form A

[mikehorse]

Hi



I always struggle to articulate issues like this, so here goes....

I'm part way through building a 2010 Access Database to track the status of various tests.

One of the area's I've come unstuck is;

I have a form called "Run TestCase" basic function is to select a set of tests, and then the actual test to be run, I've have 3 different methods I'm testing; combo box, listbox & datasheet based subform, hopefully demonstrated on the sandbox form below.




When I click the button, double click the listbox item or double click the "TEST_SCENARIO" field. Another form will open and the "Test Run Name" field populated with a concatenation of Test Set & Test Scenario.



I can get this to work with the combo box & Listbox. However, I get #Name ? with the subform method using the entry in the default value in the screenshot above. I prefer the subform route as I can use conditional formatting, not possible with listbox.

Any idea how I can get the "Test Run Name" Field to populate the way I want

Thanks in advance for any help.

[June7]

Need to know more about data structure and form/subform design. If want to provide db for analysis, follow instructions at bottom of my post.