Multiple Item Forms

[afclark82]

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.

 

[Tom van Stiphout]

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