Select Records based on Global Variable (1 Viewer)

Fozi

Registered User.
Local time
Today, 06:43
Joined
Feb 28, 2006
Messages
137
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

AWF VIP
Local time
Today, 06:43
Joined
Jul 26, 2013
Messages
7,079
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

CID Moderator
Staff member
Local time
Today, 06:43
Joined
Jan 14, 2017
Messages
13,401
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
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom