Hi,
My main form has a combo box cboDate populated with [SELECT DateComplete FROM Complete] and its recordsource = [Complete] table.
The subform has a combox NAME and 3 other textboxes for numbers entry and its recordsource = [Complete Details] table.
Main and Subform have Link Child/Parent set using [Complete ID] - autoNumber from the [Complete] table.
The user will select a date from cboDate, I have filters in place that will get its associated details and display it in the subform. The user can then edit and add records in the subform. This is working for me.
This is the problem I have now -> If the user enters a new date in the cboDate, I have to then create a new Parent record and its child data. I have a function that checks the cboDate is new and then do a AddNew for the parent. The subform is not seeing the ParentID.
I have spent yesterday and today on this
and getting nowhere ! Any idea how I can get this ID to appear in the subform ???
My main form has a combo box cboDate populated with [SELECT DateComplete FROM Complete] and its recordsource = [Complete] table.
The subform has a combox NAME and 3 other textboxes for numbers entry and its recordsource = [Complete Details] table.
Main and Subform have Link Child/Parent set using [Complete ID] - autoNumber from the [Complete] table.
The user will select a date from cboDate, I have filters in place that will get its associated details and display it in the subform. The user can then edit and add records in the subform. This is working for me.
This is the problem I have now -> If the user enters a new date in the cboDate, I have to then create a new Parent record and its child data. I have a function that checks the cboDate is new and then do a AddNew for the parent. The subform is not seeing the ParentID.
I have spent yesterday and today on this
