Button on Datasheet of subform

  • Thread starter Thread starter Sameer
  • Start date Start date
S

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
 
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
________________________
 
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
 
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
 
Back
Top