Query Using information from current line of a table

[Arweena]

This is my first post here so if you need more information please ask.

What I'm trying to do is build safeties into a database. What I want to do is have a combo box in the table that will only allow certain selections baised on another column in the table.

I can get it to limit if I use a form to get the cirteria, but I want it to grab the cirteria from the curren row of the table that I'm working in. Any ideas or help would be appriciated

Also I'm using Access 2003

Alia

[jaxjagfan]

This is my first post here so if you need more information please ask.

What I'm trying to do is build safeties into a database. What I want to do is have a combo box in the table that will only allow certain selections baised on another column in the table.

I can get it to limit if I use a form to get the cirteria, but I want it to grab the cirteria from the curren row of the table that I'm working in. Any ideas or help would be appriciated

Also I'm using Access 2003

Alia

Are your comboboxes based on tables as their data source? If so is the criteria value a column in the tables? Is one combo limiting/extending choices available in the next? Having a structure based on tables vice values allows you or users to add values and change criteria without changing code.

My end users maintain these tables since they know the business processes. I just have to maintain the application.

On the AfterUpdate property of the TextBox or Combo that is used as criteria you will need to requery the combobox that is being limited or extended.

Private Sub YourCombo1_AfterUpdate()
 
Me.YourCombo2Name.Requery
 
End Sub
 

[Arweena]

The Combo box is baised on a query of another table, but I want the criteria of the query to be the previous column in the same row of the current table.

Basically I have one table that lists all employees and lists what jobs they can do. Then in another table I want to select one of the positions and have the combo box in the next column only list thoes employess that can fill that position.