Data entry form creating new record

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

Guest

Hello,

I have a Form where all the controls are Bound to fields in a Table which is
opened by using

DoCmd.OpenForm "frmProposal", , , , acFormAdd, , "Add"

Basically I want this form to be opened to only allow Data entry for 1 record.

It seems to be working fine except if user TABs through all the controls &
after it gets to the last one then a New Record gets created.

How can this be stopped ? I only want when the Form that comes up to allow
1 record to be created.

Any help would be greatly appreciated.

Thank you,
Jeff
 
Jeff,

One way would be to use an unbound form, and append the record through code.
Another option, utilizing your current bound form, is to (a) set the
form's Cycle property (found on tab Other) to Current Record, so after
the last control a Tab or Enter sets focus back to the first one on the
same record, and (b) set the form's Navigation Buttons property (found
on tab Format) to No, so they don't exist at the bottom of the form; the
downside is this will not prevent users from going to a new record
through the mouse scroll wheel, unless additional measures are taken in
code.

HTH,
Nikos
 
Hi Nikos,

THANK YOU !! Perfect !

You found the perfect resolution for me - (a) set the
form's Cycle property (found on tab Other) to Current Record

I never knew about this Property.

Thanks again,
Jeff
 
Back
Top