Please Help?! Form to display specifc data.

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
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 said:
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 said:
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
Click to expand...
Click to expand...
 
Star man works perfect!!!!
--
Regards

Ashley Smart


Ofer said:
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 said:
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
Click to expand...
Click to expand...
 
Back
Top