Herb E wrote:
When selecting records from a combo box, everything works fine if the
Item Number is typed in.
What does "everything works fine" mean. That you can enter an Item
Number?a
For example, if I type in FC9612 it executes
properly. However, in most instances, the item number will be
selected from another program.
After you get the item number from the program do a
msgbox "Number is " & WhateverTHeVariableNameIs...just so you know it
is a valid item
I would like to copy it from the other
program and paste it into the Access form to speed up the process,
however, when I do so I recieve "The item number you entered is not
in the list."
What do you mean "Paste"? Most often I'll enter Me.ComboBox = Variable.
Is that you mean. Or do you put the variable in the clipboard and then
paste it?
This only happens if the Row Source property contains a sort
statement. If the sort clause is removed, the paste properly
executes.
The item number you enter and the item number you "paste" must be
different. Have you verified the item to "paste" really does exist in the
combo?
Any ideas how to use the paste option with the sort clause?
What is it with "paste"? Please detail further.
I'd probably do something like this. I'd create a new form. I'd create a
text box. I'd then "paste" this value into the text box and in the
AfterUpdate event of the box I'd enter
If Me.Text0 <> "FC9612" Then
msgbox "Not the same"
Else
msgbox "The same"
endif
and if not the same, I might go into the Debug/Immediate window by putting
a step flag in the code and find out why the two don't match