Combo box question

  • Thread starter Thread starter Eric G
  • Start date Start date
E

Eric G

I have a dropdown combo box on a form that displays the nine values of
a table.
Would someone be able to tell me how I can set up the combo box so
that it only displays the first eight of the nine values as choices?

COMBO BOX:
Control source: ReasonID
Row source: SELECT [Reasons].[ReasonID], [Reasons].[Reason] FROM
Reasons;
Column widths: 0";0.7"

TIA Eric
 
Hi Eric:

You have to use the TOP function. Runs something like this:

SELECT TOP 4 [Reasons].[ReasonID], [Reasons].[Reason] FROM Reasons ORDER BY
[Reasons].[ReasonID];

Regards,
Al
 
Back
Top