Forms and subforms and other crap

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello

Currently, I have a form with a subform inside of it. I've got it set up so that when I start typing a name for record entry, All the records with the same last name show up. I have to maintain files for a large number of employees both new and recurring, and I need to see if they are new or already have a record

I don't think this is the best way to do what I want. The only way to use it is to start a new record and type in their info, which works for me but I know what I'm doing. (somewhat:) I realize I can use the find function but I am developing a db for people who are illiterate with computers, I'd like it to be as simple as possible

Can I use some kind of 'Find' dialogue box that will be part of my form
Also: The subform is related(?) to the main database using the last name. However, I'd like the list of matching last names to narrow down to a list of matching first names also.
 
-----Original Message-----
Hello,

Currently, I have a form with a subform inside of it.
Click to expand...
I've got it set up so that when I start typing a name for
record entry, All the records with the same last name show
up. I have to maintain files for a large number of
employees both new and recurring, and I need to see if
they are new or already have a record.
I don't think this is the best way to do what I want.
Click to expand...
The only way to use it is to start a new record and type
in their info, which works for me but I know what I'm
doing. (somewhat:) I realize I can use the find function
but I am developing a db for people who are illiterate
with computers, I'd like it to be as simple as possible.
Can I use some kind of 'Find' dialogue box that will be part of my form?
Also: The subform is related(?) to the main database
Click to expand...
using the last name. However, I'd like the list of
matching last names to narrow down to a list of matching
first names also.
.
Click to expand...
Not quite sure what your design is so I'm guessing. Try a
Combo Box based on a query that retrieves Employee ID,
First, Last and includes a field that concantenates First
and Last. Sort by Last. Put the LAST field first in the
Combo Box (it can be hidden) and your user can start to
type a name to find an existing record. Use Employee ID
as the bound field.

Roxie Aho
roxiea at usinternet.com
 
Back
Top