Don't want to cycle thru records on form

[Brad]

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

 

[Allen Browne]

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.

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