Forms - Opening Mini Forms

[The Boondock Saint]

Hi all,
Im just wondering, Ive got a table with alot of fields, (Name, Address etc
etc) and im finding it hard to stick them all onto a form and have all the
information on the screen without having to scroll, so what i was wondering
is, Could I have a form, where it has selected information... Say... all the
contact details, and then there would be a button which would popup another
window which would have other data from that listing in it.....

Any ideas would be awesome.

Cheers Saint

 

[Rick Brandt]

Hi all,
Im just wondering, Ive got a table with alot of fields, (Name, Address etc
etc) and im finding it hard to stick them all onto a form and have all the
information on the screen without having to scroll, so what i was wondering
is, Could I have a form, where it has selected information... Say... all the
contact details, and then there would be a button which would popup another
window which would have other data from that listing in it.....

Any ideas would be awesome.

Have you looked at the TabControl? That is the easiest way to deal with this
issue. Separate Popup forms can be done but it can be difficult to manage
because multiple forms editing the same record will be treated the same as
multiple *users* editing the same record. That is to say you can get locking
conflicts unless you always save a dirty form before opening another one.

 

[PC D]

What you have is an ideal candidate to use a Tab Control. Open a new form in
design view, go to the Toolbox, select the Tabcontrol and create a tab
control on your form. You can segregate your data by putting selected data
on each page of the Tab Control. If you need more pages, select the
Tabcontrol, go to the menu at the top of the screen and under Edit I believe
you can add more pages.

Note - Your main form and all the pages of the tabcontrol constitute one
for; ie, if your main form is named "MyForm", control1 on the main form is
referred to by Forms!MyForm!Control1 or Me!Control1 and control2 on any page
of the tabcontrol is referred to by Forms!MyForm!Control2 or Me!Control2.

 

[tina]

the tab control suggested elsewhere in this thread is a good solution to
limited form "real estate". i'm just wondering, though, how many fields is
"alot"? is your data normalized?

hth

 

[StopThisAdvertising]

PC Datasheet
Your Resource For Help With Access, Excel And Word Applications 'Resource ????
Over 1175 users have come to me from the newsgroups requesting help '1175 users ????
(e-mail address removed)

--
To Steve:

Why PC D this time? Why not PCD anymore, or Access Resource or Help available or why not just PC DataSheet?
You think that changing names is vital for you?
Why don't you just get lost? No-one wants your advertising/job hunting here!
Over 600!! users from the newsgroups have visited the website to read what kind of a 'resource' you are... (rapidly increasing..)

To the original poster:
Most people here have a common belief that the newsgroups are for *free exchange of information*.
But Steve is a notorious job hunter in these groups, always trying to sell his services.

Before you intend to do business with him look at:
http://home.tiscali.nl/arracom/whoissteve.html

Arno R