Working with subforms

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

Guest

Hello

I have a main form which contains subforms. All of the data is from the same record and is used for display purposes only. I used subforms since I can use tabs and my display looks neater

The subform contains three fields that are side by side. This is great. However, Access places another three blank fields in a row below this with an * . I think this is a blank record or next record that Access is putting in for me. I am not really sure since I am new at Access. However, I do NOT want the second row with * to appear at all. Is there a way to turn this off

Thanks in advance for your time
Michae
 
You are correct: the record with the * symbol is a new record.
Access is saying, "I'm ready for a new record any time."

You will need to open the subform itself in Design View.
Not the main form, the subform.
Go to the Form's Properties list for the subform and look for the option that says "Allow
Additions."
Set that to No and then save/close the subform.
Open the main form and the new record line will not be there on the subform.
Remember though that you will not be able to add ANY new records using that subform.

--
Jeff Conrad
Access Junkie
Bend, Oregon

Mike P said:
Hello,

I have a main form which contains subforms. All of the data is from the same record and is used
Click to expand...
for display purposes only. I used subforms since I can use tabs and my display looks neater.
The subform contains three fields that are side by side. This is great. However, Access places
Click to expand...
another three blank fields in a row below this with an * . I think this is a blank record or next
record that Access is putting in for me. I am not really sure since I am new at Access. However, I
do NOT want the second row with * to appear at all. Is there a way to turn this off?
 
Mike P said:
Hello,

I have a main form which contains subforms. All of the data is from
the same record and is used for display purposes only. I used
subforms since I can use tabs and my display looks neater.

The subform contains three fields that are side by side. This is
great. However, Access places another three blank fields in a row
below this with an * . I think this is a blank record or next record
that Access is putting in for me. I am not really sure since I am
new at Access. However, I do NOT want the second row with * to
appear at all. Is there a way to turn this off?
Click to expand...

Jeff's already answered your question, but I thought I should point out
that you don't need to use subforms to present data on a tab control.
You can put some fields from the current record on one tab page, other
fields on another page, and so on.
 
I do NOT want the second row with * to appear at all. Is there a way to turn this off?
Click to expand...

Set each Subform's Allow Additions property to False. If you don't
want them changing the values that are there, also set Allow Edits to
False.
 
Back
Top