Recent content by svpreston

David, The VBA code for creating both the Region and the Country queries follows. I trust the comments will help you decipher the business rules applicable. I spent a couple more hours this afternoon attempting to debug the problem. The only thing that is not working is the physical display of...

David, Will try to get the code posted soon ... have some obligations this morning. I am not able to detect any blank rows in the records returned. When I expect one Country, the list does indeed contain that country and apparently nothing else. I can select the country and it then displays in...

David, Thanks for the prompt response ... I appreciate your efforts on my behalf. The comboboxes are identical except for names, etc. In fact, the Country combobox was created by doing a copy-paste of the Region combobox. All criteria are working as I expect. I have verified all generated SQL...

David, That is indeed what I am doing; your assumption is correct. The problem I am having is getting the Country to display in the combobox after RowSource is set to the appropriate query. If there are multiple rows returned everything works fine. If only a single row is returned then nothing...

I have 2 Comboboxes, one for Region and one for Country, and am attempting to initalize/cascade them. Here is the basic info for the the underlying tables: tblRegion ======== regionAbbreviation (Text, PK) regionName (Text) regionOverseer (Text, Foreign Key...essentially a parameter)...

Hello! Very glad to have found this site and community. My name is Spence Preston and I live in San Jose, CA, USA. I am an independent consultant with over 40 years in the computer industry ... yes, I used to be able to read Hollerith coding in punched cards and even did some plugboard...