Unanswered Question Earlier

[DaveB]

I know very little about access, so I need really
detailed simple instructions. What I'd like to do is
this. I have a table with Phone prefix's, cities,
Counties, Zip Codes, and The Thomas Guide Page in it. I'm
a plumber starting a new business. So what I'd like to do
is this: when I type in the prefix field it will bring up
the rest of the information that I've stored in the first
table as well, which is with the prefix field, and fill
all of the other items in on my form without having to
type them in. Can access do this? And how do I set it up
to do this? I'm thinking perhaps a combo box, but I don't
know how to set it up. Any help would be greatly
appreciated.

 

[Gary Miller]

Dave,

Yes, Access can do all of this. Can anyone on the list do
this magic in an email to you? No... I don't believe that
anyone is going to put in the hours that it would take with
the little information you provided.

If you are tackling this yourself, you will need to be very
specific about what bite size issues you are dealing with.
If you are trying to ask help as a whole, you may want to
hire someone who is proficient at programming in Access to
either do it, or to give you some beginner level training.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________

 

[John Vinson]

I know very little about access, so I need really
detailed simple instructions. What I'd like to do is
this. I have a table with Phone prefix's, cities,
Counties, Zip Codes, and The Thomas Guide Page in it. I'm
a plumber starting a new business. So what I'd like to do
is this: when I type in the prefix field it will bring up
the rest of the information that I've stored in the first
table as well, which is with the prefix field, and fill
all of the other items in on my form without having to
type them in. Can access do this? And how do I set it up
to do this? I'm thinking perhaps a combo box, but I don't
know how to set it up. Any help would be greatly
appreciated.

It sounds like what you want is actually something pretty simple: to
just have the combo box find a record (or perhaps several records, if
there might be more than one for a given prefix). As noted elsethread,
you probably do NOT want to store this information in a second table.

I'd suggest two different approaches: one that uses no code at all,
and the other that is a bit more complicated but perhaps a bit easier
to use.

Simple method: just use the built-in "Filter by Form" technique. Click
the "Filter by Form" icon on the toolbar; type the prefix in the form
control for the prefix (and you can type in other fields if you want
to narrow the search); and click the funnel-shaped filter icon. Your
form will now show only the record (or records) for that prefix.

Fancier method: Put a Combo Box on the form's header. If you use the
toolbox wizard, you should get the option to "use this combo to find a
record". Base it on the table of prefixes, and use it to navigate to
the form record for that prefix. If the wizard doesn't cooperate post
back, it involves writing a bit of VBA code but it's not too hard.