Prevent emtpy fields

[Dave]

One of my tables has five fields:

CellID - autonumber
SampleID - many join to another table
Canister - text
Tray - number
Spot - number

This table is the source for a subform. On this form (datasheet) if a
user presses enter through the canister, tray and spot fields or begins
to input data and changes his mind, a new record is created with
cellID, sampleID filled in but the other 3 fields empty(null). It's not
a huge deal itself but it screws up a query that has a Val()
expression. How can I ensure that there are no empty records created?

Thanks,

Dave B

BTW, thanks for all the help. This forum is a fantastic source of
information

 

[Al Campagna]

Dave,
Something is causing an Update to the record while navigating, or filling in the values
you indicated. As long as no Update occurs, Esc (1X or 2X) should wipe out the entire
record.
Check all the event code involved in the form movement. Somewhere is a Refresh, or
Requery, or some other code that is forcing an update.
Users should be using Tab to navigate between controls. Try Tab and see if that makes
any difference...

--
hth
Al Campagna
Candia Computer Consulting
Microsoft Access MVP - Candia, NH USA
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

 

[Al Campagna]

Dave,
Another tip... Make a copy of the report, and start removing any control or form code,
a few at a time, until you can navigate through those controls, and can Esc Esc to wipe
out the record.
--
hth
Al Campagna
Candia Computer Consulting
Microsoft Access MVP - Candia, NH USA
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."