Please Help?! Form to display specifc data.

[Guest]

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

 

[Guest]

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

 

[Guest]

Problem is that my field Work Instruction isn't in its own table it is in a
table amongst other fields.????
--
Regards

Ashley Smart

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

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

 

[Guest]

Star man works perfect!!!!
--
Regards

Ashley Smart

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

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