>Hi,
>
>I've created a fairly simple form with a listbox on it to select a particular client's data from an old system to convert.
>lstNames.rowsourcetype = 2-Alias
>lstNames.rowsource = tclients
>
>tClients is the only table in my DE. It gets created with a SQL statement in the beforeopentables(). I can't use a view because I'm converting data from an existing DBC and don't want to add a new view to it.
>
>My form has a method that asks what folder the Old.dbc is in and what folder the new.dbc is in. I set up paths accordingly.
>
>The form has another method that opens all of the tables from old.dbc and new.dbc outside of the DE. I know this breaks encapsulation, but I'm not trying to be perfectly oopy here.
>
>I keep getting the following message error #1130:
>'field' phrase is not found.
>You are using a command with a PROMPT clause that references an unknown field.
>
>As far as I can tell none of my files contain a command with the PROMPT clause in it. I'm not using a menu at all. I turned on event tracking and it seems to happen when the form's Activate event fires. What could the problem be? I'm ready to rip my hair out on this one. I
>
>TIA,
>Jacci
Jacci, try RowSourceType - 6 Fields instead.
RowSource should look like:
tclients.lastname,firstname
(note that alias used only for the first field.)
Nick
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison