How to pass value to child form and then store in database field
Posted on 2013-01-17
Hi. I am trying to pass a value to a child form and then store it in the underlying database. I have a customer database, the customer will have more than one lab order. The list of lab orders is a subform on the customer form in continuous form view with a command button beside each record to open that lab order. So far so good. I need to pass the lab order number to the lab samples form that opens up. (There will be several samples for each lab order so I need to group them by lab order #) I've used =[Forms]![frmLabOrder]![LabOrderNum] in the control source property of the text box. That works fine but I also need to store that number in the Lab Samples table. When I add a lab order the record won't save unless I bind the text box to the table field and manually type in the number. Help anyone?