I have a form where the user makes selections from a group of combo boxes. When finished they click a command button that concatenates these different selections and enters the result in a field on the form. After this result has been entered I want to check to see if it already exists in the underlying table. If it does exist, I want to move to that record. If it does not exist I want to move to a New record. I have tried several different approaches but none that works, obviously.
TIA
TIA