Subform w/ Unbound Form

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

Guest

I have a Form w/ unbound controls populated by a dropdown
w/ a Field having the Primary Key.

Based on the PK value, a Subform is bound to "many" values
in another Table and displays those records w/ a foreign key
having the PK value on the Main Form.

What is the best way to "design" the Subform so no "Blank"
records appear?...IE see the "star" entry row??

Each time I enter the PK record (the "one" in the one-to-many),
I'm getting an additional Blank record in the "many" Table.

TIA - Bob
 
The "star entry row" will disappear if you change the Allow Additions
setting on the subform to No. You need to look at the subform's
properties under the Data tab to change the setting.

Hope that helps!
 
Thank you.

So, I need the "Allow Additions" = "Yes"
What's the optimal setup - Allow Edits, Allow Deletions
also set to "Yes"???

I guess the Default setting for "Data Entry" is "No",
but I can still add. Better "no" or "Yes"???

Still getting some additional "Blank records".

Thoughts??

TIA - Bob
 
Um, that's not what I said. I said to get rid of that last row with
the star, you need to set the Allow Additions to No.

Allow Edits = Yes means that you can edit the existing data. Set it to
No and your data becomes read only

The Data Entry setting is used for when you are just entering data and
don't care to see any of the data that has been previously entered. If
that is set to Yes, then each time your form is opened, you won't see
any old data. The only data you will see is anything that you have
entered during that session. Set it to No, and you can see all your
data.

Still getting some additional "Blank records".

I'm not sure what you mean by that. Are you getting something like:
Record1 has data
Record2 blank
Record3 has data
Record4 has data

Like that?
 
Jeff L - Thank you for the explanations.

Getting:
Record1 has data
Record2 has data
Record3 has data
Record4 blank

Bob
 
Back
Top