Looking Up Data

  • Thread starter Thread starter supermom
  • Start date Start date
S

supermom

Hello,

I am using access to keep track of phone numbers for a
telemarketing company. I am pretty much a novice though I
did go through the entire Access book.

I have been using a form to change records in my database.
And to find a record I have been using the Find Button.

I have seen other databases where you just type the number
in the field and the record pops up. And than you can
change it or whatever. How do you set this feature up?

Thanks for your time.
 
you could try this:
open the form in design view.
if it doesn't already show Form Header/Footer sections,
click View on the menu bar and turn them on.
also in View, click Toolbox to show that toolbar if it
isn't already selected.
on the Toolbox toolbar, click the Control Wizards button
to turn it on.
click the Combo Box button (same toolbar), then click in
the form Header section where you want the control to go.
when the Combo Box Wizard dialog box opens, select the
option that says "Find a record on my form based on the
value I selected in my combo box."
the wizard will guide you thru the rest of it.
hth
 
-----Original Message-----
you could try this:
open the form in design view.
if it doesn't already show Form Header/Footer sections,
click View on the menu bar and turn them on.
also in View, click Toolbox to show that toolbar if it
isn't already selected.
on the Toolbox toolbar, click the Control Wizards button
to turn it on.
click the Combo Box button (same toolbar), then click in
the form Header section where you want the control to go.
when the Combo Box Wizard dialog box opens, select the
option that says "Find a record on my form based on the
value I selected in my combo box."
the wizard will guide you thru the rest of it.
hth


.
Thanks for your reply. I tried your suggestion but the
Click to expand...
wizard did not give me the option "Find a record on my
form based on the value I selected in my combo box."

I am using Access 97. Maybe this option is not available
on this version or maybe I just am not doing it right.

Supermom
 
hmmm, it should be there - unless your form is unbound,
which means there is no table or query name in the
RecordSource property. and if you're using the form to
change records, it is a bound form, i'll bet.
i can't think of a succinct way to guide you thru this in
a post. if you're still having trouble with it, you can
email me a copy of your db if you want. i'll set it up for
you, then email it back with a explanation so you can
learn. if you want to go that route, delete any
proprietary data (if you remove all records from a
pertinent table, a few fake records would help me),
compact the db, zip if necessary to no more than 1 MB,
then email.
 
Back
Top