How can I get my subform to update based on my form selection? That's my question, now let me give details:
I created a form with a single combobox called "LastName". I pulled this from a query called "CompileInfo" that contains 8 different data fields. There are 5 "LastName"s. I "Group By"'s the combo box so only a single occurrence of the "LastName" appears. I also set the default value to " " so nothing appears initially.
Next, I created a second form (to become a subform) as a datasheet containing all fields, including the "LastName" field. Once I get this to work, I'll hide the "LastName". In the wizard, I linked the two LastNames to update the subform.
Two issues driving my question: 1. When I run the form, before I make any selection, the subform filters to one lastname, say "Smith". When I change the "LastName" combobox, the subform does not respond (i.e., it still lists "Smith"). 2. The subform will not let me modify any data.
I tried adding a Me.Requery to several of the fields in the subform.LastName field, but with no prevail.
Hopefully, this makes sense. Thanks in advance for the help. TheHorse
I created a form with a single combobox called "LastName". I pulled this from a query called "CompileInfo" that contains 8 different data fields. There are 5 "LastName"s. I "Group By"'s the combo box so only a single occurrence of the "LastName" appears. I also set the default value to " " so nothing appears initially.
Next, I created a second form (to become a subform) as a datasheet containing all fields, including the "LastName" field. Once I get this to work, I'll hide the "LastName". In the wizard, I linked the two LastNames to update the subform.
Two issues driving my question: 1. When I run the form, before I make any selection, the subform filters to one lastname, say "Smith". When I change the "LastName" combobox, the subform does not respond (i.e., it still lists "Smith"). 2. The subform will not let me modify any data.
I tried adding a Me.Requery to several of the fields in the subform.LastName field, but with no prevail.
Hopefully, this makes sense. Thanks in advance for the help. TheHorse