Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

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

Posted on 2011-10-06
12
Medium Priority
?
282 Views
Last Modified: 2012-05-12
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
0
Comment
Question by:John Desselle
  • 6
  • 6
12 Comments
 

Author Comment

by:John Desselle
ID: 36926945
FYI, the name field is actually three fields, first name, middle name, last name!
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 36927125
and the exact steps to recreate the issue are...?
0
 

Author Comment

by:John Desselle
ID: 36927419
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
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 36928426
Start typing a name *Where*?...What form?. ...?
Again, I need the *exact* steps...
0
 

Author Comment

by:John Desselle
ID: 36930438
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
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 36960022
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
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 36960052
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
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 1500 total points
ID: 36960440
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
 

Author Closing Comment

by:John Desselle
ID: 36961540
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
 

Author Comment

by:John Desselle
ID: 36961716
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
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 36964794
Not sure, ...but I was "flip-flopping" between Access 2003/2007/2010 when making the sample, so something may have gone "wonky"...
;-)

Jeff
0
 

Author Comment

by:John Desselle
ID: 36964804
LOL, anyway, thanks for the sample.
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have had my own IT business for a very long time. I started mostly with hardware and after about a year started to notice a common theme. I had shelves with software boxes -- Peachtree, Quicken, Sage, Ouickbooks -- and yet most of my clients were…
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

578 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question