Don't want to cycle thru records on form

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

Guest

I have a form that I am using to populate a table (textboxes, combo boxes, etc.). I only want to use it to add new records to the table, I don't want to be able to cycle through existing records. When I have my form open, the mouse scroll button cycles through the records. Also, the way it is now, when I re open my form, whatever record was selected before is still on there. Is there any way to refresh my form so that it always open to a new record. Once again, all I want to do is add new records. Thanks in advance. Brad
 
Set the form's Data Entry property to yes.

If you open the form from code:
DoCmd.OpenForm "MyForm", DataMode:=acFormAdd

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Brad said:
I have a form that I am using to populate a table (textboxes, combo boxes,
Click to expand...
etc.). I only want to use it to add new records to the table, I don't want
to be able to cycle through existing records. When I have my form open, the
mouse scroll button cycles through the records. Also, the way it is now,
when I re open my form, whatever record was selected before is still on
there. Is there any way to refresh my form so that it always open to a new
record. Once again, all I want to do is add new records. Thanks in advance.
Brad
 
Back
Top