Linking forms

[Guest]

I have a database with two much information to fit on one form so I have
managed to link 2 forms. I have created a control button to open one form
from the main form and it is filtered to the same primary key, in this case
membership number. unfortunately it only does that if the second form has had
the membership number already entered.
Is it possible to not have to enter the membership number but have it
automatically appear when I open the second form for the first time

 

[Guest]

In my understanding, if your primary key is the membership number and your
form is based on the same table, unless you have an other unique value to
base your filter on ... I don't see how you can do it.

If there is too much information in one table to be shown on a single form,
would it be better to split your table? Something like : Membership header
(which can contain general information), MemberDetail ( which can contain ,
name, phone number ...)

I really dont know if it will help you but it is not bad to try.

 

[Ron2005]

I offer another solution:

On the first form that you now have:

Add a Tabsection.
On Tab1 (renamed for whatever you want) Move all of the more
unique fields (not common to all tabs)
on Tab 2 put all of the fields you have on your second form.

and on and on for as many tabs you need.

A dumb example.

Master file:
last name
first name
address 1
add 2
add 3
phone 1
phone 2


form master
last name
first name

tab object
tab 1
address 1
add 2
add 3
tab 2 object
phone 1
phone 2

Works like a charm for extensive information in single record.

Ron

 

[Ron2005]

Further, If you have login ids then you can control which tabs are
visible by rights of those ids..... etc. etc...