Did you consider making the FamIDs control a combo box or list box instead? That way, if the id does not exist, you eliminate a bunch of work with respect to
- having a query that uses the unbound control as criteria,
- having to deal with the fact that the form did not open with a record but
- then needs to be requeried against the entered id and
- then needing to decide on what to do if there is no result versus what to do if there is
Most of that can be avoided. If the desired id cannot be found in the list, you simply provide a process to add a record on that form or open any other if that's what you want.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.