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

Paste Into A Combo Box

P: n/a
When selecting records from a combo box, everything works fine if the
Item Number is typed in. For example, if I type in FC9612 it executes
properly. However, in most instances, the item number will be
selected from another program. 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."

This only happens if the Row Source property contains a sort
statement. If the sort clause is removed, the paste properly
executes.

Any ideas how to use the paste option with the sort clause?
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.