468,765 Members | 1,157 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,765 developers. It's quick & easy.

subform not showing

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
1 1910
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.

Similar topics

1 post views Thread by Txsg8r | last post: by
1 post views Thread by gavo | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by Marin | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.