The second is easy.  Go to Tools then Startup.  Put the name of your
form in the "Display Form" box.  The first is more difficult but not
very difficult.  It involves writing a bit of VBA code for the
AfterUpdate event of your search text box.  I have a form at work that
does this.  If no one else has answered your question soon, I'll send
along some more information.

----- Original Message -----
From: Mick Fitzpatrick <[log in to unmask]>
To: <[log in to unmask]>
Sent: Sunday, August 13, 2000 6:52 AM
Subject: [PCSOFT] Access query?


> First:
> The database I'm building first is a kinda address book with the usual
type
> of info in it. I'm building this mainly for practice. I've made a nice
> looking form and added 2 buttons ... one for add a person ... the
other
> delete a person. I also had one for 'find a person' but i didn't like
the
> way it searched, it launched the normal 'Find' facility. What I would
like
> to achieve is a simple text box where I will type in the search
criteria,
> then click a button, then the person will be displayed in the form ...
I
> hope I have explained that clearly?
>
> Second:
> I would like to be able to click the shortcut to the database, then
the
> database will launch, but rather than the the normal Access window, I
would
> like it to immediatley open the form I use . This is not really
essential
> I'm just curious to see if it is possible?
>

      "Hold No Punches.." Rode brings you great shareware/freeware
        programs with his honest opinions in this weekly column.
                         http://nospin.com/rode