|
| 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 |
|
#21
January 2nd, 2010, 06:13 AM
posted to microsoft.public.access.forms
|
|||
|
|||
Combo boxes...
On Sat, 02 Jan 2010 04:34:10 GMT, "thewabit via AccessMonster.com"
u57141@uwe wrote: I will add it back and see what happens. Does all the other stuff look normal? Looks good to me, as best as I can tell from this remote vantage! -- John W. Vinson [MVP] 
|
|
#22
January 3rd, 2010, 06:28 AM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Combo boxes...
I have discovered that these combo boxes are on a subform. Do I have to list
the main form AND subform somewhere in the filter? John W. Vinson wrote: I will add it back and see what happens. Does all the other stuff look normal? Looks good to me, as best as I can tell from this remote vantage! -- Message posted via http://www.accessmonster.com
|
|
#23
January 3rd, 2010, 07:27 AM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Combo boxes...
On Sun, 03 Jan 2010 06:28:20 GMT, "thewabit via AccessMonster.com"
u57141@uwe wrote: I have discovered that these combo boxes are on a subform. Do I have to list the main form AND subform somewhere in the filter? Yes, in the syntax =[Forms]![mainformname]![subform].Form![controlname] where [subform] is the name of the Subform Control on the main form (which might be different from the Name property of the Form object within that control). -- John W. Vinson [MVP]
|
|
#24
January 3rd, 2010, 04:24 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Combo boxes...
Thanks John,
I will give it a try John W. Vinson wrote: I have discovered that these combo boxes are on a subform. Do I have to list the main form AND subform somewhere in the filter? Yes, in the syntax =[Forms]![mainformname]![subform].Form![controlname] where [subform] is the name of the Subform Control on the main form (which might be different from the Name property of the Form object within that control). -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/201001/1
|
|
#25
January 3rd, 2010, 04:57 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Combo boxes...
John,
Would I find the subform control in the properties of the main form? John W. Vinson wrote: I have discovered that these combo boxes are on a subform. Do I have to list the main form AND subform somewhere in the filter? Yes, in the syntax =[Forms]![mainformname]![subform].Form![controlname] where [subform] is the name of the Subform Control on the main form (which might be different from the Name property of the Form object within that control). -- Message posted via http://www.accessmonster.com
|
|
#26
January 3rd, 2010, 05:15 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Combo boxes...
Nevermind...I got it working...I forgot to put the requery back in.
Thanks John! thewabit wrote: John, Would I find the subform control in the properties of the main form? I have discovered that these combo boxes are on a subform. Do I have to list the main form AND subform somewhere in the filter? [quoted text clipped - 6 lines] might be different from the Name property of the Form object within that control). -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/201001/1
|
|
#27
January 3rd, 2010, 05:24 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Combo boxes...
Getting closer but new problem.
The 2nd combo box which displays records based on the selection of the first, only displays records for first 9 selections in the top box. When 10-42 is selected in the first box, no records will show in the second box. Is this a properties setting? thewabit wrote: Nevermind...I got it working...I forgot to put the requery back in. Thanks John! John, [quoted text clipped - 5 lines] might be different from the Name property of the Form object within that control). -- Message posted via http://www.accessmonster.com
|
|
#28
January 3rd, 2010, 07:37 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Combo boxes...
I solved my problem...disregard.
thewabit wrote: Getting closer but new problem. The 2nd combo box which displays records based on the selection of the first, only displays records for first 9 selections in the top box. When 10-42 is selected in the first box, no records will show in the second box. Is this a properties setting? Nevermind...I got it working...I forgot to put the requery back in. [quoted text clipped - 5 lines] might be different from the Name property of the Form object within that control). -- Message posted via http://www.accessmonster.com
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
