Question on Data Entry Form

[msand]

I am working on a data entry form like this:

Date

Spend Category

Category Details

Vendor

Dollar Amount



On the spend category, there is only two choice: external & internal, which I want to use a lookup wizard. The problem is on the category details. What I want to do is: when i pick external in the Spend Category, the Category Details will only display the details subcategory (a dropdown list)for External. When Internal is picked, only Internal Category Details will be displayed in a dropdown list. Can anyboday give me a hint how I shall proceed ?

 

[bat17]

Assuming that you have a table listing the various categories called tblCategoryDetails and that this table has a field showing the spend category.
Create a query based on the tblCategoryDetails in the filed for spend category create a criteria based on the spend category combobox you created using the wizard.
Yoe will then need to add a line of code to the after Update event of your spend category box to requery the details box.
There is an example of this in the Solutions.mdb that comes with access.

HTH

Peter

 

[msand]

HI, Peter. Thanks for your help. Would you please tell me where the Solutions.mdb is and how to find it? Thanks.

 

[bat17]

It should be on your PC if you have a full instalation of Access 97 so you may be able to find it with a search. if not it can be downloaded from Microsoft
It is in 97 format but I belive it still apllies to latter versions.

HTH

Peter