subform not showing

[andrewbda]

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

[Rick Brandt]

Re: subform not showing

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