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
|
|||
|
|||
Multiple Item Forms
Hi. I am new to your form and am struggling with the Multiple Item Forms. I
want a combo box on the top that will select an id number from a table called 'SurveyA'. The multiple item form should then only display the records in a table called 'ActTravDiary' with that id number. As the ID number is changed a new group of records should be displayed in the form. I know how to initiate a change in one combo box based on another combo box (i.e. Row Source), but I cannot find a similar property for the multiple item forms. Please help. |
#2
|
|||
|
|||
Multiple Item Forms
On Fri, 12 Feb 2010 21:00:28 GMT, "afclark82" u58164@uwe wrote:
The "Multiple Item Form" is also known as "Continuous Forms". Say that you have set the RecordSource to the name of your table 'ActTravDiary'. This would show all records. Now create a combobox in the form header and bind it to a query that shows the ID and probably some description from the SurveyA table. Now create a new query on the 'ActTravDiary' table, and on the ID field set the criteria to: Forms!myForm!myCombobox Save that query and give it a name, say myQuery. Then set myQuery to be the RecordSource of the form. (of course you change myObjectNames to yours) -Tom. Microsoft Access MVP Hi. I am new to your form and am struggling with the Multiple Item Forms. I want a combo box on the top that will select an id number from a table called 'SurveyA'. The multiple item form should then only display the records in a table called 'ActTravDiary' with that id number. As the ID number is changed a new group of records should be displayed in the form. I know how to initiate a change in one combo box based on another combo box (i.e. Row Source), but I cannot find a similar property for the multiple item forms. Please help. |
Thread Tools | |
Display Modes | |
|
|