I am hoping you can help me with a combo box problem I have. The scenario is as follows:

- Form is based on a schedule
- Fields are: date, time, season, age group, visitor, home (all are combo boxes except date and time)
- After selecting season and age group, user selects visitor and home teams
- After age group looses focus, I requery visitor and home in case the user has changed age groups in order to make sure the correct team from an age group is selected.

The problem I am having is that after selecting the age group, the visitor and home teams are requerying properly, however, when I go to any other record and change the age group, the records having different age groups go blank. The data is not lost, but the data is no longer displayed. If I change back to the original age group, the teams are displayed properly again.

I am using Access 97.

Thank you in advance.

You are suffering from Jet 3.5 (Access 97). Jet 3.6 (Access 2000) handles this kind of formating.

Unfortunatly there is no direct route around this. The best suggestion I have is to have a single view form and to reset the values list of the combo boxes on the Form_Current Event.

If you must have the multiple record view you can do a little trick. Add bound listbox (only one row), the list boxes will just have all teams in them no matter what is selected, next to each of the combo boxes. Make the list boxes Locked=True and Enabled=False, this will keep them from being changed from the listboxes. Reduce the width of the combos so that only the down arrow appears and on the AfterUpdate Event of the combos update the listbox fields. Also you will need to populate the fields on the Form Current Event.

Hope this helps

For doing the multiple record option you listed, will that prevent someone from selecting from a team not in that age group?

Thanks for your response.

David

[This message has been edited by dcbk (edited 06-28-2000).]

I imported this to Access 2000 and am having the same problem. Any other ideas?

thanks