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

subform not showing

P: n/a
I am having issues with showing a subform.

Basically it is an address form, which is linked to a customer number
on the main form.

If there is an existing address record, the form always shows. However
when no matching records are there, the subform does not show. I want
it to always show.

If I switch to design view, and then back to form view, the blank
subform shows as I want it to, and data entry works fine (it creates
the record and correctly links the address with the customer).

For some reason it does not show when the from first loads.

any suggestions??

Thanks,

Andrew

Dec 21 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
andrewbda wrote:
I am having issues with showing a subform.

Basically it is an address form, which is linked to a customer number
on the main form.

If there is an existing address record, the form always shows. However
when no matching records are there, the subform does not show. I want
it to always show.

If I switch to design view, and then back to form view, the blank
subform shows as I want it to, and data entry works fine (it creates
the record and correctly links the address with the customer).

For some reason it does not show when the from first loads.

any suggestions??
That behavior indicates that your subform does not allow adding new records.
That can be caused by properties of the form itself or by properties of its
RecordSource.

If the form allowed new entries to be made then you would see the subform
positioned on the NewRecord position ready to accept a new entry.

If the form does not allow new entries and there are no current records to
show then it will appear completely blank.
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Dec 21 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.