Program a Search field

[dadtofive]

I am trying to create a form to allow a customer service rep to enter a zip
code into a search field which would display work-order info in that zip.
The problem is is that the work-orders are located in Map areas, not
zip codes. The work-orders are assigned a Map upon creation through the use
of a conversion table. Unfortunately the zip code is not possible to be
documented on the database that I have created to contain the information I
need to see about the work-orders... . Service Reps do not know the Maps,
they only know the zip codes. SO.... I have a query that translates the
entered Zip code into the corresponding Map. That is good but I need that
Map to generate a second search action to locate the row in another database.
I could ask the service rep to reenter that map area into another search
field, but I would think there is a way to create a "double function" search
field that would accept the Zip code, translate to the Map and then open the
requested database field for that map.

I have a
- ZIPtoMAP --query - Holds the data to show What Map each Zip is located.
1000's of zips translate down to 120 maps.
- DownLoadMaster --- Table ( linked to an Excel database) This table
summarizes the needed data for each of the Maps.

I want a
-Summary form that allows the service rep to enter the ZIP(or Map if known)
-Upon Enter, determine the Map from the ZIPtoMAP query
-Take that Map and search the DownLoadMaster table and show the requested
row of data

Right now I can only get it to show the Map. How can I get this Map to
auto generate a second search of another database to show the needed data?

 

[Tom Wickerath]

Are you familiar with using VBA code? This should be a do-able task, without
too much trouble. You can either open a recordset based on the zip code, or
use the domain aggregrate function DLookup, with the appropriate zip code
criteria, to locate your desired map number. Then use additional code to use
the map number to look up the data you are seeking.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

 

[dadtofive]

No I am not familiar with Visual Basic. I was hoping that there was some
built in functionality in ACCESS in the form of a wizard or something. I
will break out the VBA for Dummies book... Thanks.