|
| 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
January 1st, 2010, 10:25 PM
posted to microsoft.public.access.forms
|
|||
|
|||
Search criteria not passing to subforms
I have an cmd button on my switchboard that opens a form based on criteria
from a text box on my switchboard. I have 4 nested subforms on my form and while the form opens correctly and the Main Form displays the found record correctly, the subforms show blank. If the user tries to reenter the info - a duplicate ID (pk) error pops up. The Main form and all subs have one-to-one relationships. How can I do this command of opening w/ specific criteria and the system automatically transfer it through all of the subforms? Thanks so much! Pamela 
|
|
#2
January 1st, 2010, 11:32 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Search criteria not passing to subforms
On Fri, 1 Jan 2010 14:25:01 -0800, Pamela
wrote: I have an cmd button on my switchboard that opens a form based on criteria from a text box on my switchboard. I have 4 nested subforms on my form and while the form opens correctly and the Main Form displays the found record correctly, the subforms show blank. If the user tries to reenter the info - a duplicate ID (pk) error pops up. The Main form and all subs have one-to-one relationships. How can I do this command of opening w/ specific criteria and the system automatically transfer it through all of the subforms? Thanks so much! Pamela Do you have the Master and Child Link Field properties set correctly for the subforms? What are their Recordsources? -- John W. Vinson [MVP]
|
|
#3
January 2nd, 2010, 12:28 AM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Search criteria not passing to subforms
I figured out that I had changed the DataEntry property to Yes and had just
forgotten to change them back on the subforms... Thanks so much though for trying to help...just got a little scatterbrained! "John W. Vinson" wrote: On Fri, 1 Jan 2010 14:25:01 -0800, Pamela wrote: I have an cmd button on my switchboard that opens a form based on criteria from a text box on my switchboard. I have 4 nested subforms on my form and while the form opens correctly and the Main Form displays the found record correctly, the subforms show blank. If the user tries to reenter the info - a duplicate ID (pk) error pops up. The Main form and all subs have one-to-one relationships. How can I do this command of opening w/ specific criteria and the system automatically transfer it through all of the subforms? Thanks so much! Pamela Do you have the Master and Child Link Field properties set correctly for the subforms? What are their Recordsources? -- John W. Vinson [MVP] .
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
