The select query behind my form filters by 2 fields. On the form is an unbound field that I use for a lookup on the query to tell me the next event# to be used on the new record. Problem is the value pulled is based on the entire query rather than the filtered results I used in the selection criteria. This can’t be right, why aren’t the filtered results of the form being used. I mean if I filter the form w/selection criteria, why should I have to re-apply similar filter criteria in my vba lookup to get the right result. I shouldn’t have to, but that’s what seems to be happening.