Greetings,
I am having trouble filling the Instructor_ID field in the TBL_Visa table, see attached file.
The information is entered via FRM_NIE, which has the sub-form FRM_NIV embedded in it.
The former uses QRY_NIE and the latter QRY_NIV.
QRY_NIV has been inserted into QRY_NIE, in which the '*' has been invoked.
The problem:
The TBL_Visa gets populated, but only one, record #1, is filled, without the Instructor_ID.
When FRM_NIE is invoked later, that record is overwritten with the newer information.
I would like to keep the forms as is as the FRM_NIV can be used to update visa information in a future form.
As always, thank you for your time.
M. McAllister
FYI: 'Rachael' is fake, as is some of my info.
I am having trouble filling the Instructor_ID field in the TBL_Visa table, see attached file.
The information is entered via FRM_NIE, which has the sub-form FRM_NIV embedded in it.
The former uses QRY_NIE and the latter QRY_NIV.
QRY_NIV has been inserted into QRY_NIE, in which the '*' has been invoked.
The problem:
The TBL_Visa gets populated, but only one, record #1, is filled, without the Instructor_ID.
When FRM_NIE is invoked later, that record is overwritten with the newer information.
I would like to keep the forms as is as the FRM_NIV can be used to update visa information in a future form.
As always, thank you for your time.
M. McAllister
FYI: 'Rachael' is fake, as is some of my info.
