jharding08
Member
- Local time
- Today, 10:18
- Joined
- Feb 16, 2021
- Messages
- 55
I have a subform that has three fields - Start Date, End Date and Duration. It comes from a table that has many records, so the recordset is Select Top 1 (although there should only be one).
This subform should be able to allow for new entries, but just one, so I have to set the Allow Additions to Yes, right? If I set Allow Additions to No and there isnt a current record, it doesnt show the fields. I just want one record for this subform, but when I enter new or edit the current record and hit enter, it goes to a new record. Is there a way to limit this on New/Edit?
This subform should be able to allow for new entries, but just one, so I have to set the Allow Additions to Yes, right? If I set Allow Additions to No and there isnt a current record, it doesnt show the fields. I just want one record for this subform, but when I enter new or edit the current record and hit enter, it goes to a new record. Is there a way to limit this on New/Edit?