Help again ! Can't go to specified record ?!?!?

[Daisy]

Hello all,

I have asked this question before, but sofar didn't get a
satisfying answer

My previous question was:
I have put a 'go to next record' button on my data entry
form. However, when I click it (ofcourse after filling in
data), I get the message "You can't go to the specified
record". What's that about ? I am using Access 2003....

Now:
I have programmed the following three options, neither of
them seem to work. The latter two give me that I cannot go
to the specified record, the first one seems to work, but
doesn't. I have no clue what I am doing wrong here. It
must not be that complicated, is it ?

DoCmd.GoToRecord , , acNext

DoCmd.GoToRecord , , acNewRec

and

DoCmd.GoToRecord , , acNewRec
[Form_History of medical conditions].PERIOD.SetFocus

 

[Michel Walsh]

Hi,


Your actual data is not valid and cannot be saved. When you move out to
another record, the ACTUAL data has to be saved, and since it DID NOT, you
CANNOT move out, unless you cancel the modifications, Me.Undo, or that you
complete the required data, with valid data, and satisfying all the enforced
relations.

The same thing happen if, in Northwind, you try to add a new record to
Order Details, with the following data:

OrderId = 1
Product= Alice Mutton

You won't be able to move to another record.




Hoping it may help,
Vanderghast, Access MVP