capture new record addition

[mleczko]

Hi,

How can I capture the fact the someone has started enteringt a new
record and wants to move to another record without populating a primary
key field.

My users keep getting the 'primary key or index cannot be null' error
and it's a little frustrating

I want them to be returned to the mandatory key field before they move
on

Thanks
Nick

 

[Arvin Meyer [MVP]]

Obviously, your users have a problem with data entry. If they got that
message a few times, one would think they'd learn to fill in the field. The
best solution is to use an autonumber for your primary key. It will be
filled in automatically, relieving them of the burden of remembering to fill
it in.
--
Arvin Meyer, MCP, MVP
Free MS-Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Guest]

If you're not using an autonumber, you could trap for the mistake in the
form's BeforeInsert event. In this event, put:

If IsNull(Me.MyPrimaryField) Then
MsgBox "Primary field cannot be blank",vbbOkOnly,"Error"
Cancel = True
End If

Barry