I'm needing to create a data entry form for an organizations complete Officer list for a year. My plan was to create a small form asking the user to select Organization, Chapter # and Year from combo boxes and then clicking a button to open a data entry form listing the Officer Titles for the Organization (chosen in the combo box), a Members Name combo box (populated when they chose a specific Chapter # in the combo box) and have it auto fill in the Year when they chose it from the combo box.

I think I can get the first form to work correctly, however I'm having a hard time grasping how to generate such a data entry form from using the selections in that first selection form.

Am I looking at an impossible situation?

Bluez

Use queries to populate the lists in the entry form. Set criterias like;

=[mainfrm].[combofield (officers)]

in the organizations field, and so on with the other fields as well. (you will have to check the syntax).

For the "year" field, I think you can put something like

[mainfrm].[yearfield]

in the control source.

Hopefully, somebody will correct me if I´m wrong. It´s worth a try!

Fuga.