I have created a form in access, based on a single table query. The form displays church information (ID no, sdate, mdate, tdate, group, district, attendance).
ID sdate mdate tdate group district attendance
01 2/11/08 3/11/08 6/11.08 wuse utako 320
02 9/11/08 10/11/08 13/11/08 wuse jabi 450
03 16/11/08 17/11/08 20/11/08 Asokoro estate 300
04 23/11/08 24/11/08 27/11/08 Asokoro village 5000
The unique identifier for each record is ID no.
I can cycle through all the records using the navigation buttons currently, however in the final form those functions will be disabled. I want to change the group and district text fields to combo boxes.
Therefore the user can select a group value and the corrosponding church information will be displayed in the other text fields, changing as the group value is altered. Basically using a combo box to cycle through the records.
I have tried and exhausted every method I know and stil no luck. Please I will appreciate any help.
ID sdate mdate tdate group district attendance
01 2/11/08 3/11/08 6/11.08 wuse utako 320
02 9/11/08 10/11/08 13/11/08 wuse jabi 450
03 16/11/08 17/11/08 20/11/08 Asokoro estate 300
04 23/11/08 24/11/08 27/11/08 Asokoro village 5000
The unique identifier for each record is ID no.
I can cycle through all the records using the navigation buttons currently, however in the final form those functions will be disabled. I want to change the group and district text fields to combo boxes.
Therefore the user can select a group value and the corrosponding church information will be displayed in the other text fields, changing as the group value is altered. Basically using a combo box to cycle through the records.
I have tried and exhausted every method I know and stil no luck. Please I will appreciate any help.