Hit a brick wall - Select combo box - Open relating records or add new records

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
John DesselleAsked:
Who is Participating?
 
Jeffrey CoachmanMIS LiasonCommented:
Here is a sample of how this can be done.

I am sure that based on your experience here, you can take the info in this sample and apply it to your database.

;-)

JeffCoachman
Access-SampleComboboxAddItemNotI.mdb
0
 
John DesselleAuthor Commented:
FYI, the name field is actually three fields, first name, middle name, last name!
0
 
Jeffrey CoachmanMIS LiasonCommented:
and the exact steps to recreate the issue are...?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
John DesselleAuthor Commented:
Start typing a name, then hit Tab or Enter, it should ask you if you want to add that name, click Yes.  A new form opens up for that caller's contact info, enter in some data, then click Close Form.  I would like the name you entered on Contact form to be selected in the combo box you first entered the name into.

Then, clicking on "View all constituent's Contact Info" and it should bring up that caller's contact info.  But, since this is the same form used to enter the contact info, something weird is happening.  Guess I could make that 'view' form a separate form.  I may have solved some of the issues just now.
0
 
Jeffrey CoachmanMIS LiasonCommented:
Start typing a name *Where*?...What form?. ...?
Again, I need the *exact* steps...
0
 
John DesselleAuthor Commented:
Sorry, the auto open didn't work.  frmMain is the form to open.  Then you will see a place at the top of the form to start typing in the name.
0
 
Jeffrey CoachmanMIS LiasonCommented:
Your design, though working, is not designed properly to give you what you are looking for here.

All I can do is post a sample based on a more popular approaches...

stay tuned...
0
 
Jeffrey CoachmanMIS LiasonCommented:
Another issue here is that you are trying to use the same form to create child records and to search for a parent record
(This interface confuses many users, and they are not sure if selecting a value from the combobox will "Select" that value, or "Filter" for this value...
0
 
John DesselleAuthor Commented:
I have ended up creating two separate forms.  Thanks for the sample.  I'll keep it for a simple sample of doing this.  Seems like I will be able to use it in the future.  THANKS

One question, why when droping down the combobox can't I see any of the customer names?   And, what if I wanted to seperate FirstName, MiddleName and LastName all in that same combobox?
0
 
John DesselleAuthor Commented:
Oh wow, this is weird.  The sample you submitted works great, you know that.  But, when opened in Windows 7 running Access 2003, the Customer drop down does not show the text.  BUT, if opened in Windows XP running Access 2003 it shows up properly.  Just too weird.
0
 
Jeffrey CoachmanMIS LiasonCommented:
Not sure, ...but I was "flip-flopping" between Access 2003/2007/2010 when making the sample, so something may have gone "wonky"...
;-)

Jeff
0
 
John DesselleAuthor Commented:
LOL, anyway, thanks for the sample.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.