Hello,
I have a main form with one subform. The main form displays a record from
TableOne (PCID)
This is a corporate software tracking utility that works like this:
Main form...Choose PCID (from TableOne)
Subform..Display / Add software (from TableTwo) (linked via PCID)
Relationships:
TableOne(PCID) linked to TableTwo(PCID)
TableThree(SoftwareTitleKey) linked to TableTwo(SoftwareTitleKey)
The Subform displays query data from TableTwo based on the choosen record
(PCID) in the main form.
My problem is, after I add a new PC into TableOne in the main form, the
subform goes completely blank until I manually enter at least one record
into TableTwo by editing TableTwo directly.
Why does my subform go completely blank if there is no linked record yet in
TableTwo? Even my data entry fields and buttons dissapear which doesn't
allow me to enter the first record into TableTwo.
Thanks
Tim