[AccessD] Open a form and find a record

Well, I don't have to worry much about portability issues, but I'd be
interested in the opinions of folks better versed than I in the area of
optimization.  I was under the impression that a simple one-time call to
a domain function in a case like this is no big deal in terms of speed.
(I suppose it depends on the size of the table.)  I do avoid using them
in iterative processes, however.  

Maybe after applying the filter you could evaluate the state of the
form's underlying recordset (eof/bof) upon open (load?), and, if it's
empty, display a message box and close the form.  Just speculating here
- haven't actually tried it.



-----Original Message-----

OK.  I am doing the same thing to open a form and determine pretty much
the same kind of filter.  I get queezy using dlookups and was trying to
find a better way, not using dlookups, to achieve the same
functionality.  I was under the assumption that using dlookups is a nono
as other programs do not understand them (in the event I upgrade to
VB.net) and dlookups are slow.  Any other suggestions beside the old
dlookup method?