Hello all,
I have a question.
I have a person record, who can have many locations, and
each location can have multiple phone and fax numbers.
From the person record, I want a subform for locations in
the datasheet view where I can enter the address, city,
state etc and then for each location, on the datasheet is
there a way to have a button for entering phone numbers
and fax numbers. I know this might not be possible, but in
that case, is it possible to have a button on the subform
header where depending on which location is clicked there
is a generic button for phones and faxes. I tried this as
well, but it seems like the form does not display the
header if it is in datasheet format.
Any help will be appreciated.
Thanks
Sameer

Sameer,

This is one of the limitations of using a form in a
datasheet format. You lose access to events and specialized
controls such as command buttons. What you can do is to
redesign your form so that it 'looks like' a datasheet view.
Now you can keep your Header and have access to events.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
"Sameer" <(E-Mail Removed)> wrote in
message news:28ec01c3a96e$95a68200$(E-Mail Removed)...
> Hello all,
> I have a question.
> I have a person record, who can have many locations, and
> each location can have multiple phone and fax numbers.
> From the person record, I want a subform for locations in
> the datasheet view where I can enter the address, city,
> state etc and then for each location, on the datasheet is
> there a way to have a button for entering phone numbers
> and fax numbers. I know this might not be possible, but in
> that case, is it possible to have a button on the subform
> header where depending on which location is clicked there
> is a generic button for phones and faxes. I tried this as
> well, but it seems like the form does not display the
> header if it is in datasheet format.
> Any help will be appreciated.
> Thanks
> Sameer
>

You cant have a button on a datasheet. But there are two ways around:

1> Use a Continuous form, which you can set up to look just like a
datasheet.

2> Replace the phone/fax text fields with combo boxes, then add more entries
using the not-in-list event.


--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
"Sameer" <(E-Mail Removed)> wrote in message
news:28ec01c3a96e$95a68200$(E-Mail Removed)...
> Hello all,
> I have a question.
> I have a person record, who can have many locations, and
> each location can have multiple phone and fax numbers.
> From the person record, I want a subform for locations in
> the datasheet view where I can enter the address, city,
> state etc and then for each location, on the datasheet is
> there a way to have a button for entering phone numbers
> and fax numbers. I know this might not be possible, but in
> that case, is it possible to have a button on the subform
> header where depending on which location is clicked there
> is a generic button for phones and faxes. I tried this as
> well, but it seems like the form does not display the
> header if it is in datasheet format.
> Any help will be appreciated.
> Thanks
> Sameer
>

I approached this by having 2 subforms for each person - one, all
locations in a datasheet form, where it is easy to pick the location of
interest, another - using the same recordset - in a single form view,
with all the details editable. This way, when you select the location,
it is automatically shown in the detail view.

Pavel

Sameer wrote:
>
> Hello all,
> I have a question.
> I have a person record, who can have many locations, and
> each location can have multiple phone and fax numbers.
> From the person record, I want a subform for locations in
> the datasheet view where I can enter the address, city,
> state etc and then for each location, on the datasheet is
> there a way to have a button for entering phone numbers
> and fax numbers. I know this might not be possible, but in
> that case, is it possible to have a button on the subform
> header where depending on which location is clicked there
> is a generic button for phones and faxes. I tried this as
> well, but it seems like the form does not display the
> header if it is in datasheet format.
> Any help will be appreciated.
> Thanks
> Sameer