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

Need a combo box with only certain numbers

P: n/a
Hello..I hope someone can help me with this little that I've been
having for a while. I have a form..which has many fields. one of them
being a test #. what I need a combo box with only certain
numbers[called OOS Numbers] that match that particular test#. One
test# can have multiple OOS#s, but its must be that, Test#=OOSNumber.
I have the following code so far:

SELECT [OOS# table].[OOS Number] FROM [OOS# table] WHERE ((([OOS#
table].[OOS Number]) =
Forms!SampleSubmissionForm![SampleSubmissionTable].[Test #])) ORDER BY
[OOS# table].[OOS Number];

-OOS# table is the table when all the OOS Numbers are located..
-SampleSubmissionForm is the form where all this is located, and thats
the same form where i ned the combo box.
-Test # and OOS numbers must go with each other.

When i try to run that query, it gives me a prompt saying:
Forms!SampleSubmissionForm![SampleSubmissionTable].[Test #]))

I dont see whats wrong. Please help.
Thanks in advnce,
-Rey
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Put the query as the data source for the Combo box,
make sure that the NAME of the TEXTBOX which shows the Text# on the
form,
is Text #

Friendly advise:
I suggest avoid using special characters "#" like these in your design
and also avoid SPACES, they can make your life miserable, especially
when you build many queries, and they wont run only because instead of
one space in the name u typed in two.

Regards
Prasanna

Follow good naming conventions.
sb*********@progenics.com (Sreya) wrote in message news:<57**************************@posting.google. com>...
Hello..I hope someone can help me with this little that I've been
having for a while. I have a form..which has many fields. one of them
being a test #. what I need a combo box with only certain
numbers[called OOS Numbers] that match that particular test#. One
test# can have multiple OOS#s, but its must be that, Test#=OOSNumber.
I have the following code so far:

SELECT [OOS# table].[OOS Number] FROM [OOS# table] WHERE ((([OOS#
table].[OOS Number]) =
Forms!SampleSubmissionForm![SampleSubmissionTable].[Test #])) ORDER BY
[OOS# table].[OOS Number];

-OOS# table is the table when all the OOS Numbers are located..
-SampleSubmissionForm is the form where all this is located, and thats
the same form where i ned the combo box.
-Test # and OOS numbers must go with each other.

When i try to run that query, it gives me a prompt saying:
Forms!SampleSubmissionForm![SampleSubmissionTable].[Test #]))

I dont see whats wrong. Please help.
Thanks in advnce,
-Rey

Nov 13 '05 #2

P: n/a


Hello... the code is not working because, I have many Test #s, for one
OOS #. Somehow I just cant manipulate the code.

SELECT [OOS# table].[OOS Number] FROM [OOS# table] WHERE ((([OOS#
table].[OOS Number]) =
Forms!SampleSubmissionForm![SampleSubmissionTable].[Test #])) ORDER BY
[OOS# table].[OOS Number];

I think this is incorect because, there will not be a time when the test
# and the OOS# are the same. the format for test # is: 01-030404 and the
format for the OOS# is 1,2,...
So, how else can I write this code? please help.
Thank you.
-Rey

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.