If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
My input form isn't empty?
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 -- Why don't my grey cells communicate with each as fast as they used to? I hate getting old! Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/201002/1 |
#2
|
|||
|
|||
My input form isn't empty?
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 wrote: 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 -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/201002/1 |
#3
|
|||
|
|||
My input form isn't empty?
Hi Bruce yes I have a main table and the two related tables are linked on the
linking field. Any clues? Tony BruceM wrote: 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! Message posted via http://www.accessmonster.com |
#4
|
|||
|
|||
My input form isn't empty?
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 "TonyWilliams via AccessMonster.com" wrote: Hi Bruce yes I have a main table and the two related tables are linked on the linking field. Any clues? Tony BruceM wrote: 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! Message posted via http://www.accessmonster.com . |
#5
|
|||
|
|||
My input form isn't empty?
How about the Link Child and Link Master properties of the subform control?
TonyWilliams wrote: 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] data? Tony -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/201002/1 |
#6
|
|||
|
|||
My input form isn't empty?
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 BruceM wrote: 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] data? Tony -- Why don't my grey cells communicate with each as fast as they used to? I hate getting old! Message posted via http://www.accessmonster.com |
Thread Tools | |
Display Modes | |
|
|