Button on Datasheet of subform

[Sameer]

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

 

[Gary Miller]

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
________________________

 

[Adrian Jansen]

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

 

[Pavel Romashkin]

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