3
Contributors
3
Replies
4
Views
11 Years
Discussion Span
Last Post by nicentral
0

You should be able to fix this by checking for the existence of records before doing anything else.

In psuedo

tr = form input

move to beginning of recordset

find tr

if not rs.eof or not rs.bof then
display record
else
error message
end if

Cheers

Andy

0

Hey nicentral,

Nice Psuedo code, it's been years since I last saw that (University)!

However I think you meant to put an "AND" in here:
if not rs.eof or not rs.bof then

or maybe

If not (rs.eof or rs.bof) then

I hate it when I get caught in these little "Logic Traps"

Happy Coding

Yomet

0


However I think you meant to put an "AND" in here:

Good call Yomet! That's what happens when you don't COMPLETELY think something through before sending it off.

Cheers!

Andy

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.