> > > Hi all,
> > >
> > > I put a list inside a column of my grid and I can choose form the list but when I change the row or column the value is cleared out. I set the row source as a cursor and the controlsource as a temp table.
> > >
> > > Any advice?
> > >
> > > Thanks,
> >
> > Do you mean that the controlsource is a field in the temp table ? It should be.
> > When you change rows, browse the temp table and see what value has been stored in the controlsource field.
> >
> > Cheers,
> > Jamie
> > jamie.osborn@foxite.com
>
> Do you know if the list box will display the original value from the temp table if it has not yet been touched?

I'm not quite sure what you mean. The listbox contains a list of items that come from the rowsource. The controlsource is the field in the table that you want to be updated with the value from the listbox (ie. the field in the temp table). The value of the listbox is determined by the boundcolumn value.

IF that doesn't help - can you list the makeup of the two tables and which field you want to be updated in the temp table ?

Cheers,
Jamie
jamie.osborn@foxite.com