Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
populating a subform according to selection in main form combobox
Ok so i have corrected the query to include all the fields required , i removed the "*" ?[Forms]![ClientInformation]![searchcombo] in the debug window returns the client ID selected in the combobox in this case 2. So how do i get the subform to be populated with values returned by the query. The...- kiri19
- Post #7
- Forum: Microsoft: Access Forms
-
populating a subform according to selection in main form combobox
in the debug window ? [Forms]![ClientInfoForm]![searchcombo] returns NULL. The query is empty when run. The searchcombo property sheet is as follows: control source is empty row source: select * from ClientInformation; row source type: table/query bound column 1.- kiri19
- Post #5
- Forum: Microsoft: Access Forms
-
populating a subform according to selection in main form combobox
yes the recordsource for the visitform is visitResultsQuery you mean the syntax should be Me.visitform.requery? let me explain better. I have 2 tables "ClientInformation" and "Visits" The 2 tables are related by the clientID. ClientInformation -------------------------- ClientID -->...- kiri19
- Post #3
- Forum: Microsoft: Access Forms
-
Ms access - populating a subform according to selection in main form combobox
Thanks, i will- kiri19
- Post #3
- Forum: Microsoft: Office
-
populating a subform according to selection in main form combobox
I am new to ms access, i need some help populating a subform (visitForm) according to a selection in a combobox(searchCombo) on the mainform(clientInfoForm) so far it pulls up the info but opens up a new datasheet instead of populating the subform. In the searchCombo box on change event i have...- kiri19
- Thread
- Replies: 7
- Forum: Microsoft: Access Forms
-
Ms access - populating a subform according to selection in main form combobox
I am new to ms access, i need some help populating a subform (visitForm) according to a selection in a combobox(searchCombo) on the mainform(clientInfoForm) so far it pulls up the info but opens up a new datasheet instead of populating the subform. In the searchCombo box on change event i have...- kiri19
- Thread
- Replies: 2
- Forum: Microsoft: Office
