Excel form comboboxes to pulling data from access

[bob7777]

Trying to create a form in excel that will pull the data for multiple comboboxs
I have gotten it to work with one compobox but I cannot get the others to work.
1. combobox pull employee name from access (one table)
2. combo to pull project number (second table)
3 combo to pull tasks (third table)

not sure how to structure to get it to work.

The idea is to create a user time card for project tracking form.
then have the data exported to the access database

Would appreciate if you could point me in the right direction
been working on this for a long time.
thanks
Bob7777

Please Login or Register  to view this content.

[rylo]

Hi

Try processing each recordset, closing, then opening again for the next combobox.

along the lines of

pseudocode

Please Login or Register  to view this content.

etc....


rylo