Search results

Think I've got it. When I removed moduleName from the Control Source Access appears to have renamed by combo box - which is of course referred to in the query. Have modified the query to pick up new name and everything looks good. Thanks so much for your time.

The control source of the combo box is moduleName. After rereading your post I changed that to be blank. Now the query no longer works - it returns no entries for when there should be many. Any idea what else I may be doing wrong.

Sorry but I'm not sure I understand what you mean. The row source of the combo box is ; SELECT qryModulesForList.moduleName FROM qryModulesForList; What sort of info would you expect to see in there instead? Many thanks for your time.

Hi The combo is bound to a query which simply picks up the Module name field from the Modules table. Should I not have done it that way?

Thanks for responding. The sql is; SELECT requirements.reqId AS requirements_reqId, requirements.reqRef, requirements.reqShortName, requirements.reqDescription, reqModules.reqId AS reqModules_reqId, reqModules.modId AS reqModules_modId, Module.moduleName, Module.modDescription, Module.modId...

Hi This thread helped me with my problem but it's causing another issue. The user gets directed to a form where they choose the desired value (called Module) from a combo box. They then click a button to run the query. The query refrences the value they have picked on the form plus also...