Select Records based on Global Variable (1 Viewer)

[Fozi]

Hi folks

I have a college information system that manages two-year courses. At present we have three blocks running 15-17, 16-18 and 17-19.

I have an Autoexec Menu with buttons where users select buttons to administer data. One of these buttons is called 'Enrols'. This opens up a form containing student information.

I would like to get the user to select a specific Programme within the AutoExec Menu, which then filters the records behind each button on the form to that Programme. Eg: if user wishes to edit only 16-18 records, that is all that appears when they select Enrols.

Thanks for any assistance.

Fozi

 

[Minty]

What have you tried, how are your program periods stored - are they dates or a text field? Do they correlate to the rest of the records?

 

[isladogs]

Use a combo box or listbox with the 3 blocks as the data source.
Then in the after update event open the form filtered to the selected value