Need small form to cross ref data

[mdaniele]

I have a table with 5 fields of static data: NewProjNum, OldProjnum, Desc, Client, Mgr.
I need a simple form that will allow me to type in the New Project Number to Retrieve the old Project Number and related info. Conversely, Id like to also be able to type in the old Project number to retrieve the new project number. I've tried creating a form with 2 selector buttons and using 2 unbound combo boxes and 2 text boxes for the Project #'s and 3 text boxes for the other info. I've gotten it to retrieve the data but it's got a few problems (the listboxes don't refresh/clear the data as I want them to) and other little annoying glitches (that would be ok if I were the only person to use it) so I'm hoping someone will be able to suggest a method that works better. Thanks to any and all help.

 

[LonnieJohnson]

Your questions are unclear. You say that the list box does not clear how you want it to. How do you want it to clear? Do you actually mean the combo box?

You say there are other annoying glitches, what are they?

ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

Contact me at ==>lonniejohnson@prodev.us

May God bless you beyond your imagination!!!

 

[mdaniele]

Thanks for the help, since 1st posting, re-created the form, here's what's going on: It's a pretty simple form,
_______________________________________________________
|
| [NPN btn] [NPN combobox] [OPN textbox]
|
| [OPN btn] [OPN combobox] [NPN textbox]
|
| [ PROJINFO(textbox) ]
|
| [CLIENTINFO(textbox)] [MANAGERINFO(textbox)]
|_______________________________________________________

Our company recently changed accounting systems,the idea is to for the users to be able to cross reference a new project number to an old one by clicking on the NewProjNum button, enter in or choose from the NPN combo, and voila! the other data appears. Conversely, it is sometimes necessary to select the OldProjNum in order to retrieve the NewProjNum. Either search method produces the same PROJINFO, CLIENTINFO, and MANAGERINFO data because all 5 fields reside in the same record.
The only things I haven't been able to resolve are:
once I use either button, the text boxes retain the prior info.

i.e. let's say NPN = 123456 OPN = ABCDEF

I select NPN and enter into the NPNcombo 123456, the OPNtextbox displays ABCDEF (that part's perfect), but (because I use the same field) the NPN textbox also displays ABCDEF.
If I then use the OPN btn and enter GHIJKL, 123456 remains in NPN Combo until I execute another search.
Although it's working, the form data becomes confusing.

So, all I need to do is automatically clear all the fields whenever I either select either one of the buttons or combo boxes.

Ideally, and if not pressing my luck even further, I'd like to make it even simpler by doing away with both the OPNtextbox and NPNtextbox, and have just the combo boxes show the NPN and OPN.