Choice in Field brings up LookUp Table in another Field

[newstrom]

I am trying to figure out how to create a macro or code so that when I make a selection from a drop down box it will bring up a corresponding lookup table drop down box in another field.

Example:
In field "File Location" I select "Boss Files", and in the next field "File Topics" it lists all of the topics of the boss' files, such as Current Job Bids, Banking Contacts, Equipment, Ect.

Or In field "File Location" I select "Accounting Files", and in the next field "File Topics" it lists all of the topics of the accounting files, such as AP, Taxes, Employees, Etc.

This prevents me from having to go through 1000 file topics that belong to the whole company.

 

[Rich]

search here for cascading combo boxes, there have been many examples

 

[newstrom]

Still confused regarding cascading combos

I am unable to unzip the examples that users have submitted and I can't seem to understand if I use some of the code examples as macros or properties.

The best I've come up with is creating a macro as below:

IIf ([form]![Main Filing Entry Form]![FileLocation] = Accounting*, [Form]![Main Filing Entry Form]![TopicFiledUnder]=

![Lookup Table - TopicFileUnder - Accounting], «falsepart»)

I know this is so far off isn't embarrassing.

I also tried doing a query with iif statements but I can't figure out the logic to get the "RowSource" in "File Topics" to change to the right LookUp table.

I notice on the examples that Me. is use. Is that part of the syntax that I need to use.

If you could direct me to a website example or if someone could send some examples via a regular email as a access database so I can actually see how it works then I'm sure I could figure it out.

Sorry to sound so stupid