I am trying to create a command button that allows a subform to pop up in my Main form (parent form).
The relationship between this 'Parent' and 'Child' is a one-to-one relationship and when the subform pops up it won`t relate this subform to the 'parent' form. i.e. i would expect the PrimaryKey Autonumber to automatically appear as it would if the subform was normally visible on the Main Form.
I then get a message saying 'Index or Primary key cannot contain Nll Value' when i try to close the popup subform. The data type in the Table for both are correct.
I`m fairly new to Access so any advice would be appreciated.
The relationship between this 'Parent' and 'Child' is a one-to-one relationship and when the subform pops up it won`t relate this subform to the 'parent' form. i.e. i would expect the PrimaryKey Autonumber to automatically appear as it would if the subform was normally visible on the Main Form.
I then get a message saying 'Index or Primary key cannot contain Nll Value' when i try to close the popup subform. The data type in the Table for both are correct.
I`m fairly new to Access so any advice would be appreciated.