I've been fighting with what I thought would be a simple database to track calls.
Caller calls, you start typing their name in the field, if found sub form populates with their previous calls. If they are not found, a new caller form opens and you add their contact info. HERE IS ISSUE: Once contact info is added, I want the combo box on main form to be that person's name, and subform open for new record.
I have buttons to view currently selected caller's history, and one to view their contact info. HERE IS ISSUE: if viewing contact record, when form closed, main form updates to last caller viewed.
I am sorry if I am talking in circles, but my brain has hit a brick wall. My Contact info form isn't even working anymore.
Anyone care to take a look and see what they think? CallLog.mdb