null data when creating a new record

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

Guest

i am using access 2000 with custom forms. here is the problem.

a user fills out the form and thus creates a table record. a user then
repeats the process to create a second, third, fourth, etc. record.

when the second, third, fourth, etc. records are created the form always
jumps back to the first records information and dispalys its data.

i would like the form to display blank (null) data when i am creating a new
record.

thanks for your help.
 
curtis said:
i am using access 2000 with custom forms. here is the problem.

a user fills out the form and thus creates a table record. a user then
repeats the process to create a second, third, fourth, etc. record.

when the second, third, fourth, etc. records are created the form always
jumps back to the first records information and dispalys its data.

i would like the form to display blank (null) data when i am creating a new
record.

thanks for your help.
Click to expand...

Then you have something wrong. Displaying blank is what DOES happen when you go
to a new record. Are you sure your user isn't just changing the same record
rather than creating new ones? Unless you mean that the user is...

Creating the first record
Closing the form
Opening the form to create a second record.

In that case then yes the form will open at the first record unless you do
something about it. Sounds like you need the form's DataEntry property set to
true. With that applied the form always opens at a new blank record position.
 
rick thanks for the response.
i did more checking. i have a button on the initial form. the button has an
on click event pocedure that is suppose to save/create the record and goto
the next form. however when it saves the record, it saves it back to the
first record in the table instead of to a new record. Then it pulls the first
record data and displays it on the next form.

should i be looking for correct code that saves and creates a new record??
 
curtis said:
rick thanks for the response.
i did more checking. i have a button on the initial form. the button has an
on click event pocedure that is suppose to save/create the record and goto
the next form. however when it saves the record, it saves it back to the
first record in the table instead of to a new record. Then it pulls the first
record data and displays it on the next form.

should i be looking for correct code that saves and creates a new
Click to expand...
record??

I don't understand why you would be using code to save the record. A bound
form would do this for you automatically. If you are not using a bound
form please explain why and then post the code from the button. It's
pretty hard to say what is wrong with it without seeing it.
 
Back
Top