 |
|
 |
|
On Sat, 07 Nov 2009 07:58:01 -0700, Tom van Stiphout <...@cox.net
On Sat, 7 Nov 2009 16:30:43 +0200, "Nick Dakoronias"
<...@gmail.com
The form may not be named "Combo Form" or the combobox may not be
named "Category".
-Tom.
Microsoft Access MVP
>Rgds, Nick.
|
|
 |
|
 |
|
|
|
|
On Sat, 7 Nov 2009 10:01:14 -0500, "Ken Snell" <...@ncoomcastt.renaetl
Assuming that the form is named "Combo Form" and that the first combobox
control is named "Category", the code should work fine.
Normally, when running a SQL statement within a form this way, one doesn't
use the Forms![Combo Form]! syntax, and instead just uses the name of the
control:
WHERE (((Products.CategoryID)=
[Category]))
Is the second combobox on a subform, and the first combobox on a main form
that holds that subform?
--
Ken Snell
http://www.accessmvp.com/KDSnell/
"Nick Dakoronias" <...@microsoft.com...
|
|
|
|
|
|
|
|
|
On Sat, 7 Nov 2009 10:03:03 -0500, "Ken Snell" <...@ncoomcastt.renaetl
see reply in other newsgroup where you posted this question.
--
Ken Snell
http://www.accessmvp.com/KDSnell/
"Nick Dakoronias" <...@microsoft.com...
|
|
|
|
|
|
|
|
|
On Sat, 7 Nov 2009 07:53:01 -0800, Beetle <...@discussions.microsoft.com
First thing to check would be the spelling of the form
and combo box names. Is your form named Combo Form?
Is your first combo box named Category?
--
_________
Sean Bailey
>
|
|
|
|
|
|
|
|
|
On Sat, 07 Nov 2009 16:34:34 -0700, "Tony Toews [MVP]" <...@telusplanet.net
"Nick Dakoronias" <...@gmail.com
Open the forms. Open the query in design view and click on the box
containing the above field and clear it. Then click on the Build
button on the toolbar (looks like a wand with some stars), make the
box bigger by dragging on the lower right corner, then expand the
Loaded Forms item on the left hand side. Click on the form and you
will see a list of the controls in the middle box. Select the control
and click on Paste. Then click Ok.
Now the correct form and control name will be in the criteria field in
the query. Assuming this is a typo of some sort of course.
Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a free, convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/
|
|
|
|
|
|
|