M
Michael
I am having a problem with a combo box after update procedure.
I have a combo box called "itemcode" in a sub form called
"accountsreceivable" which pulls itemcode data from my table
"itemcodes".
When you select the drop down, it displays 3 columns: itemcode, price,
& description. It displays all these fields and the data in these
fields without an issue. I have an after update function that auto-
fills the price & description fields of the "accountsreceivables" sub
form after you select the itemcode you want.
The problem is this:
Any item code which starts with the letter "R" or "L" will not
"afterupdate". All other itemcodes work correctly (unless I've missed
another finicky letter). For example, the itemcode "Rhombus" will not
work with the afterupdate. The item code "zRhombus" will function
with the afterupdate.
Does anyone have any ideas why this is happening?
I have a combo box called "itemcode" in a sub form called
"accountsreceivable" which pulls itemcode data from my table
"itemcodes".
When you select the drop down, it displays 3 columns: itemcode, price,
& description. It displays all these fields and the data in these
fields without an issue. I have an after update function that auto-
fills the price & description fields of the "accountsreceivables" sub
form after you select the itemcode you want.
The problem is this:
Any item code which starts with the letter "R" or "L" will not
"afterupdate". All other itemcodes work correctly (unless I've missed
another finicky letter). For example, the itemcode "Rhombus" will not
work with the afterupdate. The item code "zRhombus" will function
with the afterupdate.
Does anyone have any ideas why this is happening?