General information
Category:
Forms & Form designer
Title:
Combobox replaces with bound alias
To All,
I have this combobox problem:
Style = 2 dropdown list
populated with a RowSourceType 3 - SQL statement
SELECT CODE.pk_code, code, descr from CODE ;
where codetype = "PCODE" and not empty(code) ;
order by code into cursor curPCODE
BoundColumn = 2
ColumnCount = 3
control source is pparent.pcode
tables are:
Pparent
+->Child
Code
The problem is, when the form is activated, whatever value may be in Pparent.pcode, for instance "PC01" is replaced by "Pparen", the first six letters of the alias of the table bound to the combobox. ??
The combobox display field is empty.
If I make a selection from the combobox, save, close, and browse Pparent, my selected value is there.
If I do not make a selection from the combobox, close, refuse the save prompt offered by the check to GETFLDSTATE(), confirm the refuse, and browse Pparent, my original value is there.
In either case, on entry, the value is replaced by the alias
What am I overlooking?
Thank you
Al Allison
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only