populating combo box

odomene

New member
Local time
Today, 14:44
Joined
Nov 5, 2008
Messages
7
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.
 
Not entirely clear on your objective.
But why not have two combo boxex on your from that dispaly the church and district instead of text boxes, then when you get to a new record they will just select one from the list.
 
I have tried and exhausted every method I know and stil no luck.
Where exactly is the difficulty? You can populate a combobox like this:

cbo.RowSource = "SELECT empName FROM tblEmployees"
cbo.LimitToList = True 'prevents the user typing random data.

The user's selection will then be stored as cbo.Value.

I'm not good with databinding, so I'd leave my textboxes unbound.

txtEmpID.Value = DLookup("EmpID", "tblEmployees", "empName='" & cbo.Value & "'")
 
Thanks for your respond. Actually, I want to get all the church information display by selecting any value in the group combo box rather than populating through the record button.
 
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.

Hello Odomene,

Follow the link below and I believe this will aid you in accomplishing what your after.

HTH,
Shane

Link: http://www.mvps.org/access/forms/frm0005.htm
 

Users who are viewing this thread

Back
Top Bottom