Need help doing something in Access

  • Thread starter Truman - USW Local 985 Webmaster
  • Start date
T

Truman - USW Local 985 Webmaster

Okay, I have created my table with information and I created a form that I
can access when i open the whole program. At a previous job, I would click on
a file and it would just open the form only and I could search through the
records by typing the persons name at the top of the form. I want to be able
to do this with my database but I dont know how. I am using access 2007 and
lost. Dont know what I'm doing. Can anyone please help and give me idea's -
Thanks so much
 
B

bhicks11 via AccessMonster.com

Hi Truman,

You could put a combobox control that you type in/look up the person's name
and when you tab off the control it populates the other controls. Or if you
want to work in the actual data, just use the combobox to select which record
to set focus on.

Post more details if you need more help.

Bonnie

http://www.dataplus-svc.com
 
J

JulieS

"Truman - USW Local 985 Webmaster" <Truman - USW Local 985
[email protected]> wrote in message
Okay, I have created my table with information and I created a form
that I
can access when i open the whole program. At a previous job, I would
click on
a file and it would just open the form only and I could search
through the
records by typing the persons name at the top of the form. I want to
be able
to do this with my database but I dont know how. I am using access
2007 and
lost. Dont know what I'm doing. Can anyone please help and give me
idea's -
Thanks so much
Click to expand...

Truman,

To show the form you've created when you first open the database
you'll need to set that form to display when the database is opened.
Click the Office button and select Access Options at the lower right
edge.
Click the "Current Database" listing on the right.
Under Application Options, select your form from the Display form
list.

To add the box at the top of the form to find a specific record, show
your form in design view. Click the Design tab and in the Controls
section, make sure the Use Controls Wizards is on.
In the Controls section, click the Combo Box control and when the
wizard starts, selection the option "Find a record on my form....."
the wizard will step you through the rest.

I hope this helps.

Julie
 
Top