Please HELP! - Combo Box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I created a form which includes several combo boxes where I use Value List
as the Row Source Type that work fine. However there is one combo box where
I use Table/Query as the Row Source Type that I am having trouble with. I
also used an input mask to accept only length of characters per box.

Table (RecRsnAct) consists of 2 columns:
RecRsnAct Reason
00 Ineligible
01 Moved
02 - 09 " So on
10 - 19
20 - 30
99

When I type 00 it will not advance to the next combo box. When I type in 01
through 09 it only keeps the last digit. When I type 25 it only keeps the 2
and moves to the next combo box. I would like for it to store both digits.

I am sort of new at this and can't seem to figure out why the other boxes
are working fine but this one is not.

I explained as best as I could. Any help is appreciated.
 
Hi Lou,

Wouldn't you rather just show your users the Reasons without the numbers in
front? Set your first column to 0" width.

HTH,
Brian
 
Back
Top