Adding records in Subform

  • Thread starter Thread starter Pat
  • Start date Start date
P

Pat

Hi.
I set the subform properties to Allow Additions = No
because I want users to click an Add Record button to get
another row in the subform. However, if you add a record,
the minute you enter text in a field, it adds the next
row, and that row is enabled to data input. Can I change
that --- the user will not see a blank row (or next row)
until they click the Add Record button.

Thanks.
Pat
 
Pat,

One way to do it is, instead of switching to Allow Additions = Yes, open a
new form with unbound text boxes, where the user does the data entry, and a
command button to (a) save the the data as a new record in the target table
(through a recordset operation), (b) close the data entry form and (c)
requery the subform on the original form.

HTH,
Nikos
 
Back
Top