THIS HAS BEEN SOLVED. SOMETHING MESSED UP AND CANNOT PUT SOLVED ON THE THREAD TITLE
My idea was this...When entering a new record into the main form and discovering that the Part Number I'm trying to enter isn't in the db yet (indexed), that by clicking on the Enter New Part Number button, type in new number, exit the Enter New Part Number form, and resume back to my main form at the same record I was originally on with the main form having been requeried so now the new Part Number will show up in my combo box.
Any suggestions?
Attachment 6025