DB can't input data in form, eliminate blank record in subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am showing correct data in a form and associated subform, based on a query.
In the main form Additions = yes, Data Entry = no
The query is working correctly. Locks = No, Link child and Link Master are empty.

In the subform, there is a blank record at the bottom which I don't want.
for the subform, additions = no and Data Entry (new records) = no.
 
-----Original Message-----
I am showing correct data in a form and associated subform, based on a query.
In the main form Additions = yes, Data Entry = no
The query is working correctly. Locks = No, Link child and Link Master are empty.

In the subform, there is a blank record at the bottom which I don't want.
for the subform, additions = no and Data Entry (new records) = no.
.
Click to expand...
Hi Desert Bear, I'm not sure what you're asking...

If you are wanting to show in the subform records related
to the one in the main form you will need to have a common
linking field in both the child and master properties of
the subform control.

In the same manner that a blank main form record is
displayed when there are no records in the form record
source or when you move to a new record, the subform
displays a blank record when there are no matching related
records to the main form record (and also for new records,
when allowadditions=yes).

If you don't want to display the subform when there are no
matching/related records you can search this usergroup for
possible solutions as this particular question has been
asked before.

Luck
Jonathan
 
Back
Top