|
|
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.
|
|
0
|
|
|
|
Reply
|
 afclark82
|
2/12/2010 9:00:28 PM |
|
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.
|
|
|
0
|
|
|
|
Reply
|
Tom
|
2/13/2010 2:59:18 AM
|
|
|
1 Replies
722 Views
(page loaded in 0.088 seconds)
Similiar Articles: Multiple Item Forms - microsoft.public.access.formsHi. 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 ... Filtering a multiple item form - microsoft.public.access ...Hello, I have VBA code that works perfectly for filtering a form by one or more fields. I am trying to get the same code to work on a multiple items form - where the ... Multiple items in text box on a form? - microsoft.public.access ...I want a text box to display items from a table and text together? so the MainTable collects quantity, color and price which is enter through antother form. select multiple items from dropdown - microsoft.public.access ...hello everyone, i have a table which is populated using a form. one of the fields is person's name, the dropdown for which picks up data from a seco... adding multiple items to a subform - microsoft.public.access ...I am using access 2003. I am attempting to setup an inventory database for equipment that we loan out to various clients. I have followed the Northw... multiple item select from a combo box - microsoft.public.access ...I want to use this as a navigational tool, rather than to "input" values into a database. This control will be on a form that sets parameters for gr... fixed form size - microsoft.public.accessI have created a Form with Various Sub forms. One of my Subforms is an Item form where Multiple Items can be bought. I have designed the page so when... How do I sum multiple fields relating to a single field in a form ...How do I sum multiple fields relating to a single field in a form ... Filter Form to get a data relating to a date field - microsoft ... Filtering a multiple item form ... Multiple-criteria search on form, to open form - microsoft.public ...Filtering a multiple item form - microsoft.public.access ..... Search Post ... ... Hi All I want to open a form with multiple criteria To Open Form: Bag From Form ... Troubleshooting Access Forms - microsoft.public.access.forms ...Multiple Item Forms - microsoft.public.access.forms Filtering a multiple item form - microsoft.public.access ... One other troubleshooting idea is to comment out all but ... Create a form by using the Multiple Items tool - Access - Office.comA multiple item form, sometimes referred to as a continuous form, lets you show information from more than one record at a time. A multiple item form can resemble a ... Multiple Edit Form for Sharepoint List Item - CodeProjectHow to customize New or Edit Form (NewForm.aspx or EditForm.aspx). How to make multiple custom edit form for different item status. How to link those Forms with the ... Create a form by using the Multiple Items tool - Access - Office.comA multiple item form, also known as a continuous form, lets you show information from more than one record at a time. The data is arranged in rows and columns ... Creating Microsoft Access Forms - Free Online TutorialsYou can use the Multiple Items button on the Forms tab to create a form that displays multiple records, one record per row. To create a multiple items form: Creating A Multi-Item Paypal Order Form | Formstack BlogFirst, we'll build a form with two item fields and two quantity fields. Next, we'll go to Settings > Payment Integration > PayPal and choose Multiple Items instead of ... 7/21/2012 12:55:22 AM
|
|
|
|
|
|
|
|
|
Search |
Post Question |
Groups |
Stream |
About |
Register
38 followers. 