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
|
|||
|
|||
"Find" in subform (Access 2007)
I have a subform on a main form (created from tables with 1:N relationship).
I need to be able to "find" a record in a subform and have that record and it's parent record show. Documentation in Access Help says that you can only use "find" in the parent form. Has anyone found a way to work around this? -- lighthouse118 |
#2
|
|||
|
|||
"Find" in subform (Access 2007)
Nope. The only records available to search in the subform are the ones that
are related to the main form. You can add an unbound comb box on the main form to do searching using a query with both tables joined. Have the combobox display both the main and sub information. Once you find the item then search the main form. -- KARL DEWEY Build a little - Test a little "lighthouse118" wrote: I have a subform on a main form (created from tables with 1:N relationship). I need to be able to "find" a record in a subform and have that record and it's parent record show. Documentation in Access Help says that you can only use "find" in the parent form. Has anyone found a way to work around this? -- lighthouse118 |
#3
|
|||
|
|||
"Find" in subform (Access 2007)
Thanks Karl. I am trying to make your suggestion work. So far I am not doing
so good, but I will figure it out. Like you say: Build a little - Test a little -- lighthouse118 "KARL DEWEY" wrote: Nope. The only records available to search in the subform are the ones that are related to the main form. You can add an unbound comb box on the main form to do searching using a query with both tables joined. Have the combobox display both the main and sub information. Once you find the item then search the main form. -- KARL DEWEY Build a little - Test a little "lighthouse118" wrote: I have a subform on a main form (created from tables with 1:N relationship). I need to be able to "find" a record in a subform and have that record and it's parent record show. Documentation in Access Help says that you can only use "find" in the parent form. Has anyone found a way to work around this? -- lighthouse118 |
#4
|
|||
|
|||
"Find" in subform (Access 2007)
Is there a way to 'goto' the main record when you select the one you want in
the combo box? "KARL DEWEY" wrote: Nope. The only records available to search in the subform are the ones that are related to the main form. You can add an unbound comb box on the main form to do searching using a query with both tables joined. Have the combobox display both the main and sub information. Once you find the item then search the main form. -- KARL DEWEY Build a little - Test a little "lighthouse118" wrote: I have a subform on a main form (created from tables with 1:N relationship). I need to be able to "find" a record in a subform and have that record and it's parent record show. Documentation in Access Help says that you can only use "find" in the parent form. Has anyone found a way to work around this? -- lighthouse118 |
#5
|
|||
|
|||
"Find" in subform (Access 2007)
"pcbins" wrote in message
news Is there a way to 'goto' the main record when you select the one you want in the combo box? Assuming the combo is unbound, see: Using a Combo Box to Find Records at: http://allenbrowne.com/ser-03.html -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. |
Thread Tools | |
Display Modes | |
|
|