troubleshooting Question

Combo Box

Avatar of Kdankwah
KdankwahFlag for United States of America asked on
Microsoft AccessMicrosoft Applications
13 Comments1 Solution595 ViewsLast Modified:
What I am doing is to set the dept field as a Combobox or dropdown and when you pick a dept number the segment, dept desc and segdesc is autofilled.  Its not working and I don’t know what I am doing wrong?  See below for specs

AfterUpdate event

Private Sub cbodept_AfterUpdate()
Me.txtDepnmdesr = Me.cbodept.Column(3)
Me.txtSegm = Me.cbodept.Column(4)
Me.txtSegdescr = Me.cbodept.Column(5)
End Sub
Query sql in Row source of deot cbo

SELECT [Department and Segment table].ID, [Department and Segment table].Dept, [Department and Segment table].Segment, [Department and Segment table].Dept_Desc, [Department and Segment table].Segment_Desc
FROM [Department and Segment table];

Data of the query in the rowsource of the dept field combox

ID      Dept            Segment      Dept_Desc            Segment_Desc
1      0701101      07000001      General             Promise Programs
2      0701101      00000000      General            Undefined Segment

Join our community to see this answer!
Unlock 1 Answer and 13 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 13 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros