Subform register visible

[jokobe]

When opening a form, my subform isn't visible. This subform contains a
register with two forms (register card mother and register card father). The
user can open a popup and from there the subform is made visible, but only
one register card at once. This is working fine for the second register card,
when trying to make the first register card visible, both are shown, (mother
and father) and not only mother. Why is it working for the second but not for
the first register card???

 

[JaRa]

How is the data stored for the 2 cards? Are they added in the same table? How
do you seperate between those 2 records, in other words what are the keys you
use for the subform in order to get the correct record?
Are you sure that you have created both records (mother / father)?

 

[jokobe]

They both share the same table. I use a filter with one field.
Strange thing is, it worked before, but now it isn' working any more. But
now, the second register card is empty and shown, before only the selected
register card was shown.

 

[JaRa]

Can you give me the recordsource which you use for the subform?

If it's a query i also need the sql statement.

 

[jokobe]

It's like this:
REGISTER: named register_parents
card1 : sub_mother
form name on card: f_t_mother
source: table parents

card2 : sub_father
form name on card: f_t_father
source: table parents

The records are selected with the IntId number

To show one register card I use this code, invoked when clicking
a button in the popup form:

[Forms]![f_t_child].[mother] = IntId
[Forms]![f_t_child]![register_parents].Visible = True
[Forms]![f_t_child]![sub_mother].Visible = True
[Forms]![f_t_child]![f_t_mother].Visible = True
[Forms]![f_t_child]![mother_check] = -1


jokobe

 

[JaRa]

So you have 1 main form containing 2 subforms sub_mother and sub_father which
are tied to the table parents?
When do you create a new record or is this created by the user as needed?
--
- Raoul Jacobs

The nature of developping is sharing knowledge.

It's like this:
REGISTER: named register_parents
card1 : sub_mother
form name on card: f_t_mother
source: table parents

card2 : sub_father
form name on card: f_t_father
source: table parents

The records are selected with the IntId number

To show one register card I use this code, invoked when clicking
a button in the popup form:

[Forms]![f_t_child].[mother] = IntId
[Forms]![f_t_child]![register_parents].Visible = True
[Forms]![f_t_child]![sub_mother].Visible = True
[Forms]![f_t_child]![f_t_mother].Visible = True
[Forms]![f_t_child]![mother_check] = -1


jokobe

Can you give me the recordsource which you use for the subform?

If it's a query i also need the sql statement.

 

[jokobe]

There is 1 main form. In this main form is a register with two pages
(sub_mother and sub_father), on the first page is a control called
f_t_mother, the second page holds f_t_father. In both controls is the same
form, and both pages have the same recordsource. The record is already in the
table. Within the popup all valid records are shown, the user selects one
record to be displayed in the main form on the register card. The popup is
closed, when selecting a record.

So you have 1 main form containing 2 subforms sub_mother and sub_father which
are tied to the table parents?
When do you create a new record or is this created by the user as needed?
--
- Raoul Jacobs

The nature of developping is sharing knowledge.

It's like this:
REGISTER: named register_parents
card1 : sub_mother
form name on card: f_t_mother
source: table parents

card2 : sub_father
form name on card: f_t_father
source: table parents

The records are selected with the IntId number

To show one register card I use this code, invoked when clicking
a button in the popup form:

[Forms]![f_t_child].[mother] = IntId
[Forms]![f_t_child]![register_parents].Visible = True
[Forms]![f_t_child]![sub_mother].Visible = True
[Forms]![f_t_child]![f_t_mother].Visible = True
[Forms]![f_t_child]![mother_check] = -1


jokobe

Can you give me the recordsource which you use for the subform?

If it's a query i also need the sql statement.

--
- Raoul Jacobs

The nature of developping is sharing knowledge.


:

They both share the same table. I use a filter with one field.
Strange thing is, it worked before, but now it isn' working any more. But
now, the second register card is empty and shown, before only the selected
register card was shown.

:

How is the data stored for the 2 cards? Are they added in the same table? How
do you seperate between those 2 records, in other words what are the keys you
use for the subform in order to get the correct record?
Are you sure that you have created both records (mother / father)?

--
- Raoul Jacobs

The nature of developping is sharing knowledge.


:

When opening a form, my subform isn't visible. This subform contains a
register with two forms (register card mother and register card father). The
user can open a popup and from there the subform is made visible, but only
one register card at once. This is working fine for the second register card,
when trying to make the first register card visible, both are shown, (mother
and father) and not only mother. Why is it working for the second but not for
the first register card???

 

[JaRa]

Wait wait

First get terminilogy right

the main form contains pages so you use a tabcontrol?
And i understand that you popup something when click on the button but what?

What are the form names?
And which are subforms and in which form are they embedded?
Why do you use a popup?

--
- Raoul Jacobs

The nature of developping is sharing knowledge.

There is 1 main form. In this main form is a register with two pages
(sub_mother and sub_father), on the first page is a control called
f_t_mother, the second page holds f_t_father. In both controls is the same
form, and both pages have the same recordsource. The record is already in the
table. Within the popup all valid records are shown, the user selects one
record to be displayed in the main form on the register card. The popup is
closed, when selecting a record.

So you have 1 main form containing 2 subforms sub_mother and sub_father which
are tied to the table parents?
When do you create a new record or is this created by the user as needed?
--
- Raoul Jacobs

The nature of developping is sharing knowledge.

It's like this:
REGISTER: named register_parents
card1 : sub_mother
form name on card: f_t_mother
source: table parents

card2 : sub_father
form name on card: f_t_father
source: table parents

The records are selected with the IntId number

To show one register card I use this code, invoked when clicking
a button in the popup form:

[Forms]![f_t_child].[mother] = IntId
[Forms]![f_t_child]![register_parents].Visible = True
[Forms]![f_t_child]![sub_mother].Visible = True
[Forms]![f_t_child]![f_t_mother].Visible = True
[Forms]![f_t_child]![mother_check] = -1


jokobe
:

Can you give me the recordsource which you use for the subform?

If it's a query i also need the sql statement.

--
- Raoul Jacobs

The nature of developping is sharing knowledge.


:

They both share the same table. I use a filter with one field.
Strange thing is, it worked before, but now it isn' working any more. But
now, the second register card is empty and shown, before only the selected
register card was shown.

:

How is the data stored for the 2 cards? Are they added in the same table? How
do you seperate between those 2 records, in other words what are the keys you
use for the subform in order to get the correct record?
Are you sure that you have created both records (mother / father)?

--
- Raoul Jacobs

The nature of developping is sharing knowledge.


:

When opening a form, my subform isn't visible. This subform contains a
register with two forms (register card mother and register card father). The
user can open a popup and from there the subform is made visible, but only
one register card at once. This is working fine for the second register card,
when trying to make the first register card visible, both are shown, (mother
and father) and not only mother. Why is it working for the second but not for
the first register card???

 

[jokobe]

From the main form the user can click to open a popup. Within this popup the
user can select a recordset. This recordset is to be displayed in the tab
control (sorry: over here it is called register, expected it to be the
english name too). The tab control contains two pages. The first page for t
he mother, the second page for the father (of a child from the main form).
The main form is called f_t_child, the popup f_t_parents_overview. The tab
control is register_parents with the two pages sub_mother, sub_father.
Once the user have found the person he is looking for in the popup, he
selects the person via a button. This selected person is to be shown in the
tabcontrol, and depending wether it is a mother or a father in the first page
or the second page.

Wait wait

First get terminilogy right

the main form contains pages so you use a tabcontrol?
And i understand that you popup something when click on the button but what?

What are the form names?
And which are subforms and in which form are they embedded?
Why do you use a popup?

--
- Raoul Jacobs

The nature of developping is sharing knowledge.

There is 1 main form. In this main form is a register with two pages
(sub_mother and sub_father), on the first page is a control called
f_t_mother, the second page holds f_t_father. In both controls is the same
form, and both pages have the same recordsource. The record is already in the
table. Within the popup all valid records are shown, the user selects one
record to be displayed in the main form on the register card. The popup is
closed, when selecting a record.

So you have 1 main form containing 2 subforms sub_mother and sub_father which
are tied to the table parents?
When do you create a new record or is this created by the user as needed?
--
- Raoul Jacobs

The nature of developping is sharing knowledge.


:

It's like this:
REGISTER: named register_parents
card1 : sub_mother
form name on card: f_t_mother
source: table parents

card2 : sub_father
form name on card: f_t_father
source: table parents

The records are selected with the IntId number

To show one register card I use this code, invoked when clicking
a button in the popup form:

[Forms]![f_t_child].[mother] = IntId
[Forms]![f_t_child]![register_parents].Visible = True
[Forms]![f_t_child]![sub_mother].Visible = True
[Forms]![f_t_child]![f_t_mother].Visible = True
[Forms]![f_t_child]![mother_check] = -1


jokobe
:

Can you give me the recordsource which you use for the subform?

If it's a query i also need the sql statement.

--
- Raoul Jacobs

The nature of developping is sharing knowledge.


:

They both share the same table. I use a filter with one field.
Strange thing is, it worked before, but now it isn' working any more. But
now, the second register card is empty and shown, before only the selected
register card was shown.

:

How is the data stored for the 2 cards? Are they added in the same table? How
do you seperate between those 2 records, in other words what are the keys you
use for the subform in order to get the correct record?
Are you sure that you have created both records (mother / father)?

--
- Raoul Jacobs

The nature of developping is sharing knowledge.


:

When opening a form, my subform isn't visible. This subform contains a
register with two forms (register card mother and register card father). The
user can open a popup and from there the subform is made visible, but only
one register card at once. This is working fine for the second register card,
when trying to make the first register card visible, both are shown, (mother
and father) and not only mother. Why is it working for the second but not for
the first register card???