By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,963 Members | 1,238 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,963 IT Pros & Developers. It's quick & easy.

MS-Access 2003 & SQL Server

P: n/a
I have a form in a Access Project (SQL DB on the back end). On this form I
have created a Combo box that pulls a list of dept and dept #'s from the
DEPT table, and displays the dept name in the Combo box. I tried a view
instead of a table but the Combo box would not update. On this form I also
have a sub form. The sub form has on it, among other things, the following
fields; SVCCODE, SVCODE TOTAL. I also have hidden on the sub form a GLCODE
and GLDESC fields.

What I need to happen is when the Main form Combo box is changed to a new
dept desc, let say Radiology, I want the subform to display the radiology
SVCCODE's only.

What is actually happening is when the form opens a list of SVCCODES are
displayed, I am not sure what they are connected to, and when I choose a
dept name from the combo box the SVCCODE's display, on the subform, the
department list of service codes. For example when I open the form, the
subform starts off with the list of service codes I mentioned above and the
Combo box is blank, but then when I change to a different department, in the
combo box on the main form, the subform does not display those SVCCODE
records correlating to the main forms combo box, instead it displays the
SVCCODE's for the department in the list from the department table. So if I
change to Radiology, it does not care and displays the BLOOD BANK SVCCODE's,
those being the next department.

One side note I can hit enter with the Combo box highlighted on the main
form and the subform will change its list of SVCCODES.

I need to know how make the link between the combo box and the sub form work
correctly.

Thanks in advance for any help!!
Mike
m charney at dunlap hospital dot org
Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.