Hi
I would like to know should i create 1 form or 2 forms i have 2
deperment working on the same table but first half is taken care of by
1 dept. and the other half by other dept. eg from project inition date
to approval its on deparment so i created that form the other half is
by other department
but the other department will need customer information form 1st form.

can someone guide me how do i do that.

"access baby" <nishkrish@gmail.comwrote in message
news:1176388652.399275.78790@q75g2000hsh.googlegro ups.com...

Hi
I would like to know should i create 1 form or 2 forms i have 2
deperment working on the same table but first half is taken care of by
1 dept. and the other half by other dept. eg from project inition date
to approval its on deparment so i created that form the other half is
by other department
but the other department will need customer information form 1st form.
>
can someone guide me how do i do that.
>

Use one form and two queries. Set the form's record source to the
appropriate query depending on who is opening it.

Keith.
www.keithwilby.com