2 combo boxes affecting a list box

[bloody_football]

I am new to Access so this may seem simple to some but I have searched the forum board and can't find an answer. I'm using access 2000.

I have created a query with 4 columns, the last column does a count of the third column and all works fine (hopefully the example below can give show what I mean) -

Location Status Type Count
-----------------------------
NSW On Hire PS2 23
NSW On Hire PS4 154
etc etc

A) Now I have 'Location' and 'Status' as combo boxes, my first problem is that neither will let me choose from them even though the drop down menu's are correct - it gives me the 'This recordset is not updateable'.

B) Next problem is that I have is when I choose 'Location' and 'Status' the third column of 'Type' should be produced in a list based on what the uses has chosen from the combo boxes, how do I get 'Type' to use the values chosen?

James

 

[pacg]

James

One solution:
1. Create a form without a source
2. Create a combo for location (1 colum)
3. Create a combo for status (2 colum) with criteria for 2.
4. Create a combo (3 colum) with criteria for 2. and 3.
5. Now create a textbox (with your query) that performs the calculation

Hope i help
pacg

 

[Pent]

Can you explain how to do step 4 properly
I've tried to create a query with criteria from combobox 1 and 2, but my third combo box using the query doesn't pull anything up, even though it should.

 

[bloody_football]

Thanks Pacg for the answer, unfortunately I hadn't subscribed to my own question (thought it subscribed by default) so only just saw your answer