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