Combo Box Troubles

Accessdj

Registered User.
Local time
Yesterday, 16:26
Joined
Dec 14, 2012
Messages
12
I've tried many times in varies Forms to follow the steps on Datapig with setting up 2-cbxes. I created a Form called, Co_Cityfrm with the, 'Co' 'City' & 'ZipCode' (the 'ZipCode' fld is really irrelevant) The 1st cbx is the 'Co' (cbxCo) & for the Row Source I have: SELECT Co_City.Co FROM Co_City GROUP BY Co_City.Co ORDER BY Co_City.Co; This cbx is unbound. In the 2nd cbx which is the 'City" (cbxCty) for the Row Source I have: SELECT Co_City.Co FROM Co_City WHERE (((Co_City.PostOffice)=[forms]![Co_Cityfrm].[Co])) GROUP BY Co_City.Co ORDER BY Co_City.Co; For the Control Source I have: "City" which may or may not be correct? My object with these 2-cbx is, depended upon which 'Co'= is selected, I only want to see those "Cities" associated with the selected 'CO'. Right now I'm able to select a Co, but when I try selecting a City i'm asked for a Paramenter Value???
 
If access asks for parameter value, it means that a reference in a query is to non existing field and access asks for its value. What is the name of the parameter value access is asking for?

I only add GROUP BY if I use any of aggregate function such as count(), avg(), sum() etc. I never used that in a manner you do. How about creating event On Change() for cbCo in which you populate / fill cbCity according to what is selected in cbCo?
 
I am also new to access and had similar problem .
I had inadvertently selected the parameter button on the top left of screen .It may be worth checking
good luck
 
:sorry that should have been top right next to the totals button
 
JT, My problem is trying o get the 2nd cbx to show data, Now I'm just getting blank when I drop down the menu
 
Hi have you done th requerie bit as shown in the example .if you havent that might be the problem .If the 2nd combo happens to be blank when you set it up it will remain blank unles it has the requerie after update
 

Users who are viewing this thread

Back
Top Bottom