save and reset form

S

Sibes

I am at a loss here..

I am trying to let user save the record and then be able to enter another
record starting from the top of the form.

I can not get the primary key fields to clear and I can not get the form to
start at the top again.

HELP!!

~smile~
 
R

Rick B

Typically, you would symply press PAGE DOWN or click on the "new" button
(>*) at the bottom of the form.
 
S

Sibes

Rick B said:
Typically, you would symply press PAGE DOWN or click on the "new" button
(>*) at the bottom of the form.
Click to expand...

I have tried that and it
Yes it does clear the form but it doesnt set it back at the top.

so half way there?

is there a way to reset the form to the first box?
 
J

John Vinson

I am at a loss here..

I am trying to let user save the record and then be able to enter another
record starting from the top of the form.

I can not get the primary key fields to clear and I can not get the form to
start at the top again.
Click to expand...

You're doing something odd then!

What's the Recordsource of the form? Also, check the Form's
Properties: is the Cycle property "All Records" or "Same Record"?

Normally, one would enter fields, and when you tab out of the last
field in the tab order, Access will save the record and open a new
blank one. You have to do some extra work to NOT get this behavior!

John W. Vinson[MVP]
 
R

Rick B

Check your tab order.

--
Rick B



Sibes said:
I have tried that and it
Yes it does clear the form but it doesnt set it back at the top.

so half way there?

is there a way to reset the form to the first box?
Click to expand...
 
Top