>Hi Guys
>
>I have this form for maintaining bus operator details.
>Now one operator (company) may be owned by another operator (company).
>So the Operator table appears twice in the DE - one with alias "OPERATOR1" as opposed to the default.
>
>The subject Operator table has a foreign key to its owner (ie another operator rec - which, btw, I don't have as a cyclic reln. in the DD). Just for the purposes of this form I have that pointing at the operator ID of OPERATOR1 in the DE. SO on the form I have a listbox to the OPERATOR1 "version" of the table, so that the subject operator's rec can have its owner selected froom the listbox.
>
>Now then, only trouble is the listbox is empty at runtime. Now I developed this a few years ago and I can't see that I let this flaw go in testing.
>
>Any ideas? BTW it definitely is the same table USEDd AGAIN.
>
>'ppreciate it
>
>Terry

Hi Terry,

Not sure, if this would help, but try to do listbox.requery() in the Activate method of the form (only the first time).