Command button

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

Guest

Hi,

I created command buttons: "New record", "previous", "next", "find".
When I open the form is on the new record.
but after I enter the data, when I click on "new record", there is a
message: You can't go to specified record.
The same thing happen when I click on "previous", "next", "find".

What is doing wrong, I created the buttons by wizard.

Thanks!
 
In
Hong said:
Hi,

I created command buttons: "New record", "previous", "next", "find".
When I open the form is on the new record.
but after I enter the data, when I click on "new record", there is a
message: You can't go to specified record.
The same thing happen when I click on "previous", "next", "find".

What is doing wrong, I created the buttons by wizard.
Click to expand...

What version of Access?

Please post the code for each button's Click event.

I assume that the form is bound to a table or query. Correct?

Is it possible that the record you've just entered can't be saved, due
to some validation rule or required field that is missing?

Does this happen when you are on a new blank record, or only when you
have entered the data for a record and haven't saved it yet?
 
If you open the form when the DataEntry property of the form is set to Yes,
the form will be open ready to input data in a new record, and the rest of
the records won't be displayed in the form.
In that case you won't be able to move between records because they are not
there, and you'll get this message, that you can't move to the specific
record.

If that the case, open the form with the DataEntry property of the form is
set to No, and move to the new record using the button you created.
 
Yes, it's from a query.

I found out the problem is when I enter duplicate record.
I use this form to update information to follow up.
When I enter the record #, I have a text box using look up the information.
Then I can enter the other information: customer feedback. date....

So when I enter the record # is already exsit. then the problem happen.

Thank you so much for your response.
 
In
Hong said:
Yes, it's from a query.

I found out the problem is when I enter duplicate record.
I use this form to update information to follow up.
When I enter the record #, I have a text box using look up the
information. Then I can enter the other information: customer
feedback. date....

So when I enter the record # is already exsit. then the problem
happen.
Click to expand...

If I understand you correctly, your question has been answered. Is that
right? If not, please feel free to follow up.
 
Back
Top