My input form isn't empty?

[TonyWilliams via AccessMonster.com]

I have a form with two subforms. All three forms have the Data Entry property
set to Yes. The main form only has one control called txtmonth and the two
subforms are linked to the main form on this control. However when I input a
value to the control on the main form the subforms are populated with data
from their related tables. Why aren't my subforms empty for me to add new
data?
Tony

 

[BruceM via AccessMonster.com]

Do you have a table with two related tables (a parent table and two child
tables) for the form and two subforms? If so, be sure to set the Link Master
and Link Child properties of the subform control to the name of the linking
field. If you do not do this the subform will show all of the records in its
recordset.

 

[TonyWilliams via AccessMonster.com]

Hi Bruce yes I have a main table and the two related tables are linked on the
linking field.
Any clues?
Tony

Do you have a table with two related tables (a parent table and two child
tables) for the form and two subforms? If so, be sure to set the Link Master
and Link Child properties of the subform control to the name of the linking
field. If you do not do this the subform will show all of the records in its
recordset.

I have a form with two subforms. All three forms have the Data Entry property
set to Yes. The main form only has one control called txtmonth and the two

[quoted text clipped - 3 lines]

data?
Tony

 

[Daryl S]

Tony -

Are all records showing up in the subforms, or just some?

Is the field that is bound to the txtmonth on the main form a unique field
in the recordsource (primary key or unique index)?

If you enter a value into txtmonth that has matching records in the subform,
then they should show up.

--
Daryl S

Hi Bruce yes I have a main table and the two related tables are linked on the
linking field.
Any clues?
Tony

Do you have a table with two related tables (a parent table and two child
tables) for the form and two subforms? If so, be sure to set the Link Master
and Link Child properties of the subform control to the name of the linking
field. If you do not do this the subform will show all of the records in its
recordset.

I have a form with two subforms. All three forms have the Data Entry property
set to Yes. The main form only has one control called txtmonth and the two

[quoted text clipped - 3 lines]

data?
Tony

--
Why don't my grey cells communicate with each as fast as they used to? I hate
getting old!



.

 

[BruceM via AccessMonster.com]

How about the Link Child and Link Master properties of the subform control?

Hi Bruce yes I have a main table and the two related tables are linked on the
linking field.
Any clues?
Tony

Do you have a table with two related tables (a parent table and two child
tables) for the form and two subforms? If so, be sure to set the Link Master

[quoted text clipped - 7 lines]

 

[TonyWilliams via AccessMonster.com]

I think the links must have somehow corrupted. I deleted the links, saved and
closed the forms and then reopened them in design mode and re-created the
links and everything work fine. Pity there's no way of telling when things
get corrupted as you then end up searching for errors that aren't there!
Thanks for all you help.
Tony

How about the Link Child and Link Master properties of the subform control?

Hi Bruce yes I have a main table and the two related tables are linked on the
linking field.

[quoted text clipped - 6 lines]