By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,731 Members | 1,129 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,731 IT Pros & Developers. It's quick & easy.

Subform going completely blank

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
The Detail section of the form goes completely blank if both:
a) there are no records, and
b) no new records can be added.

The 2nd condition can be caused by setting the form's AllowAdditions
property to Yes, or if the form's RecordSource is a query where new records
cannot be added.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Tim Graichen" <Tg*******@neo.rr.com> wrote in message
news:7B*******************@fe2.columbus.rr.com...
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.

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.