Dynamically updating drop down menus

[Jan_Rogowski]

Hi all

I'm a bit of an amateur but I've muddled through to a point where I've built my database pretty much to spec. It's basically a timesheet system.

I'm now setting up a form that allows easy input of the relevant information. The form is simple...

Tables are...

My question is this. Particular tasks are only relevant to certain projects, but all taken from the 'Tasks' table. At the moment when I select the 'Task' drop down on my form I see all the tasks in the table. What I want to happen is that when a particular project is selected the tasks drop-down on my form is filtered to show only the relevant options.

I've introduced the 'Type' table to specify which groups of tasks should belong to which projects but I've no idea how to implement the filtering. I've a suspicion this is quite easy but can't seem to get my head round it!

Best,
Jan.

 

[AnOddExperiment]

Hi Jan,

I'm new to this also, and sadly I couldn't tell you exactly how to accomplish what you want to do, but I do know where there is some information on what you need, which I believe are commonly called "cascading combo boxes." The moderator at this forum has a website at

http://www.btabdevelopment.com/main/

If you go there, click on the top left where it says "coding samples" and there is a sample on combo boxes you can explore and look into design view to see how it was done. Good luck, and if this dosen't help you, keep trying. There are good folks on this forum.

 

[coastguard]

Thanks,

This looks like it might help me as well