Any MS Access Experts out there? Need help!

[Joebob]

I'm trying to do something in Access (2010) which I would imagine shouyld be quite easy, but I cannot find a solution.

All I want is for a field, wether in a table or a form, to autopopulate according to the information entered into the field before it!

i.e. If I have a field called 'Vendor', with a dropdown list containing Adobe and Microsoft. Then I want the second field called 'Software' to have a dropdown list of either Adobe software or Microsoft software according to the selection from the first list.

Is this possible?

 

[Joebob]

All really useful answers, thank you. I have enough now for what I need to do - I must admit I thought it would have been automated more in newer versions of access, rather than having to input code!

 

[Joebob]

Easiest way to do it is to bind the rowsource property of your second combo box to a select query. That way you can avoid code completely.

If this is going to be multiuser, high concurrency then avoid binding any controls in any forms else you will encounter some problems.

Ok, I have tried this but cannot get it working.

I made a table with both Vendors and Software. Then created a query.

I made a simple form with just vendor, using a lookup running from the lookup in the table - then I put a combo box into the form and linked it to the select query.

How do I get the select query to use the vendor data which I select?