Cannot select specific numbers within a form

  • Thread starter Thread starter Sreya
  • Start date Start date
S

Sreya

Hello...I'm having a bit of troublw with selecting a specific field in
a table. What I need is to select a field called OOS Number from a
table called OOS# table. This is the code I have:

Code:
--------------------------------------------------------------------------------

SELECT Distinct [OOS# table].[OOS Number] AS [OOS] FROM [OOS# table]
ORDER BY [OOS# table].[OOS Number];
--------------------------------------------------------------------------------
it gives me ALL the OOS Numbers, not just the specific one that goes
with the record. How do I make it so that, as soon as I scroll
down...and as the Test numbers are scrolling down, only the specifc
numbers are in the value list of the combobox. Meaning, One test# can
have multiple OOS Numbers...and for one Test #, the combo box should
contain only those numbers that go with that certain Test #.
Any suggestion would be helpful. Thanks in advance.
-Sreya
 
Hi,


You have to add a WHERE clause, like

Me.ListBoxControl.RowSource= "SELECT *
FROM myTable
WHERE testNumber=FORMS!FormName!ComboBoxName"




If you don't use a RowSource, a ControlSource or DoCmd, you would have to
embed the value in the query, rather than referring to its holder (the combo
box name).



Hoping it may help,
Vanderghast, Access MVP
 
Back
Top