Hello,

MSAccess97 & WindowsNT

Here is the problem:
I have a form which displays information about an user. If you click on a
command button, a subforms for holidays appears, if you click on another
button, the previous subform disappears and another appears for flights
... yes, I didn't want to work with tabs ....

Besides that, I would like to have a drop down box (combobox) from which
the database user can select a name, and then the appropriate record will
appear .. i.e.:

Choose User: .the combox..

Name: shadedbox         firstname: shadedbox

phone: shadedbox
email: shadedbox

----------------------------------------------------------------------------

|Room for subforms
|
|
|
|---------------------------------------------------------------------------
--

Is this possible? if so, can someone show me the way? .... I really need
help on this one .....

Thanks in advance,

Bertrand.

Hi.
    Use the wizard to set up the combo box. Build a subform showing your
'name' etc. fields.
Then link the subform to the combo box.  Make sure that the data source for
the subform also includes a field that is in the combo box.

Simeon.

--
----
------------
Simeon Theobald,
  Palmerston North,
     New Zealand.