|
| 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
January 23rd, 2006, 09:02 AM
posted to microsoft.public.access.forms
|
|||
|
|||
Please Help?! Form to display specifc data.
Morning all,
I have a number of records each of which has fields entitled Work Station and Work Instruction. The Work Instruction field is individual to each record, whereas the Work Station could be the same for any number of records. I would like to pick the Work Station from a combo box and then have all the Work Instructions listed for that Work Station in a similar list/combo box. How do I go about this....? I Hope I have explained this well enough, please help.... Kind Regards, Ash -- Regards Ashley Smart 
|
|
#2
January 23rd, 2006, 10:03 AM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Please Help?! Form to display specifc data.
Check this link for one example
http://www.databasedev.co.uk/filter_combo_boxes.html ================= The other option is to link the row source of the second combo to the selection of the first combo Select Field1 From TableName Where Field2 = Forms![FormName]![Combo1Name] On the After Update event of the second box write Me.[Combo 2 Name].Requery To refresh the list -- \\// Live Long and Prosper \\// BS"D "A. Smart" wrote: Morning all, I have a number of records each of which has fields entitled Work Station and Work Instruction. The Work Instruction field is individual to each record, whereas the Work Station could be the same for any number of records. I would like to pick the Work Station from a combo box and then have all the Work Instructions listed for that Work Station in a similar list/combo box. How do I go about this....? I Hope I have explained this well enough, please help.... Kind Regards, Ash -- Regards Ashley Smart
|
|
#3
January 23rd, 2006, 11:40 AM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Please Help?! Form to display specifc data.
Problem is that my field Work Instruction isn't in its own table it is in a
table amongst other fields.???? -- Regards Ashley Smart "Ofer" wrote: Check this link for one example http://www.databasedev.co.uk/filter_combo_boxes.html ================= The other option is to link the row source of the second combo to the selection of the first combo Select Field1 From TableName Where Field2 = Forms![FormName]![Combo1Name] On the After Update event of the second box write Me.[Combo 2 Name].Requery To refresh the list -- \\// Live Long and Prosper \\// BS"D "A. Smart" wrote: Morning all, I have a number of records each of which has fields entitled Work Station and Work Instruction. The Work Instruction field is individual to each record, whereas the Work Station could be the same for any number of records. I would like to pick the Work Station from a combo box and then have all the Work Instructions listed for that Work Station in a similar list/combo box. How do I go about this....? I Hope I have explained this well enough, please help.... Kind Regards, Ash -- Regards Ashley Smart
|
|
#4
January 24th, 2006, 08:10 AM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Please Help?! Form to display specifc data.
Star man works perfect!!!!
-- Regards Ashley Smart "Ofer" wrote: Check this link for one example http://www.databasedev.co.uk/filter_combo_boxes.html ================= The other option is to link the row source of the second combo to the selection of the first combo Select Field1 From TableName Where Field2 = Forms![FormName]![Combo1Name] On the After Update event of the second box write Me.[Combo 2 Name].Requery To refresh the list -- \\// Live Long and Prosper \\// BS"D "A. Smart" wrote: Morning all, I have a number of records each of which has fields entitled Work Station and Work Instruction. The Work Instruction field is individual to each record, whereas the Work Station could be the same for any number of records. I would like to pick the Work Station from a combo box and then have all the Work Instructions listed for that Work Station in a similar list/combo box. How do I go about this....? I Hope I have explained this well enough, please help.... Kind Regards, Ash -- Regards Ashley Smart
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Date range on reports | Mark_Milly | Setting Up & Running Reports | 10 | January 19th, 2006 03:49 PM |
| Excel Macro to Copy & Paste | [email protected] | Worksheet Functions | 0 | December 1st, 2005 01:56 PM |
| Need Help In Printing Current Record in Specific Report | RNUSZ@OKDPS | Setting Up & Running Reports | 1 | May 16th, 2005 09:06 PM |
| Adding staff photographs to my database | KK | New Users | 2 | September 3rd, 2004 07:41 AM |
| Upload Image | Jason MacKenzie | General Discussion | 1 | September 1st, 2004 04:38 AM |
Linear Mode
