You're absolutely right!. I didn't think widely enough as to how the
visible/invisible properties impact on the final display on the form. It
finally dawns on me as to what you were getting at. My apologies for not
visualizing fast enough what you were explaining. Of course, piling controls
on top of one another in design view may be a little tricky to work with in
designing the main form. I tried your suggestions and they are very close to
what I'm striving for. Unfortunately, I tried placing the subform in the
background (in design view) so I could see the other controls and fields that
I want to super-impose over the subform, hoping they would be in the
foregorund and the subform would be in the background. But the subform, in
design view, always remains in the foreground and hides my other controls and
fields, making modifications or moving them around less easy. Of course,
this can be corrected simply by temporarily reducing the size of the subform,
so I can work on the underlying controls and fields, then return the subform
to its normal size when closing out of the design view.
You've been a very big help to me and I once again want to express my
appreciation for your speed in answering my questions and for providing me
with an excellent solution to my needs.
Sprinks said:
Tank,
The subform doesn't take up any space. In Design View, you can place
controls, including a subform, directly on top of other controls. When the
top one is Invisible in form view, you'll be able to see and edit the
controls underneath it.
I've used this technique with multiple subforms all on top of each other,
toggling the one I want to use Visible and the others Invisible. Should work
perfectly for you with such a crowded form.
Hope that helps.
Sprinks
Tank said:
Good point, Sprinks. For clarification, I mean taking up space on the form
itself. I worked with numberous pages on the form. I don't really want to
dedicate a page to listing multiple phone, fax, numbers and email addresses
on the name/address page, as I just don't have room for an array of contact
phone numbers, etc for each person. Of course if I limit myself to one or
two phones and a fax and an email address, I can squeeze that information on
the name address page, but it would be a lot easier if I just clicked on a
control button on the name/address page that would let me look at (and
edit/add) the muti-phones, etc for that individual, then close the "pop=up"
form when I no longer need to view it. That way I can use the space on the
form for other more important information. If I make an embedded subform
visible/invisible, as you suggest, I still cannot use the space the embedded
subform takes up on the main form.
:
Tank,
I must not understand what you mean by "take up space" and/or "Pop up". My
understanding was that you meant space "on the screen", and that by "pop up",
you meant showing it when you need to, and putting it away when you don't.
Am I missing what you mean?
Sprinks
:
Thanks again, Sprinks. I'll try your suggestion, but it really doesn't
address the "Pop-Up" preference. If I still have to embed the subform
somewhere on the main form, visible or not, it's still taking up space.
One workaround I tried, but not totally satisfied with, is to create a
pop-up for the subform itself (not embedded) and add a dialog in the query,
asking me to enter the ID number for the particular record when the query is
runs. This then gives me only those records in the subform pertaining to the
displayed record in my main form. I can then view the contents of the
subform, as it relates to the record in the main form. However, if I want to
add a new record in the sbuform, I need to add the appropriate ID to a new
line of the subform to correspond with the displayed record in the main form.
This is a fairly good workaround for me, as I know what I'm doing. But to
expect another user, not as familiar with this procedure, is asking a lot of
that person.... not at all a good idea to use for a less experienced data
entry person.
:
Hi, Tank.
Insert the subform on your main form, and set the links as normal. Set the
subform control's Visible property to No in form design view, and add a
command button with the following code to toggle the subform On and Off.
Me![YourSubform].Visible = Not Me![YourSubform].Visible
Hope that helps.
Sprinks
:
Is there a way to use or make an embedded subform function as a Pop-up form
when clicking on a control button -- instead of having the embedded form
displayed on a page in a form?
For example, I'd like to have a pop-up, editable list for phone-fax numbers,
inclduing email addresses for a specific record displayed in my form. This
would allow me to hide all the numbers (for the purpose of saving space)
until I need to see or edit them. Of course, the contact information would
need to be linked to the current record, as it is when using an embedded
sub-form.
