I'm sorry, I'm really having problems envisioning what you're trying to do,
and given how long this thread has gone on, it's unlikely anyone else is
reading it.

It might be worth starting a new thread, explaining what your table
structure is and what it is you're trying to accomplish with your form.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"zSplash" wrote in message
...
Thanks, Doug. I see what you're saying. But, I guess my "form" is really
more of a "report". Say in my report I always want to see any Originator,
Developer, Instigator, Procrastinator data for the project. So, I have 4
"lines" in my report:
labelOriginator | OriginatorFirst | OriginatorLast | Originator Assistant
| Originator DOB

How would I make it so that the Originator data is ever-present in the
report, and the Developer data is ever-present, and the Instigator data,
usw? I don't want anything to be "chosen", but I want to be able to
always "see" the data. How do I code for that, and where do I put the
code?

TIA

"Douglas J. Steele" wrote in message
...
Base the form on the query that returns everything (i.e.: all names, all
name types, etc.)

Once you know what name they're looking for, have a button they click on.

Assuming the button is on the same form as where you're displaying the
results, in the Click event for that button, set

Me.Filter = "Person = '" & Me.txtSearch & "'"
Me.FilterOn = True

or, if you want to let them only enter a part of the name,

Me.Filter = "Person LIKE '*" & Me.txtSearch & "*'"
Me.FilterOn = True

Alternatively, you can have them key in the name on a special Search
form, and then have the button open the other form for you, using
something like

DoCmd.OpenForm "MyForm", acNormal, , "Person LIKE '*" & Me.txtSearch &
"*'"

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"zSplash" wrote in message
...
Hi, Doug. Thanks again. I'm trying to show all projects, with
originators, developers, etc., for each project. (There are 1500
projects.) I have a search form that opens on startup. They then
search for a name, and can open the mainForm from the results list. In
the mainForm, they can see/enter the originator, developer, etc, and
other data about the project.

TIA