Hi Sarosh.
>> Is it possible to create a computed column in a grid and still be able to edit it?
I have a column in a grid with it's controlsource set to the lookup() function which returns the description (of its foreign key column) <<
Sure. If you want to drop a combo box in the column, when the combo gets focus you will be able to edit the contents of the column. From the sound of it, you are getting the contents of the column from a lookup table anyway.
Just set the bound to propewrty of the combo to true and bind it to the foreign key in the grid's RecordSource. But I think that you will need to set the bound property of the column to .F. for this to work.
I use this trick myself, but I generally set the column's controlSource to Something like this:
=SEEK( < foreign key field in RecordSource >, '< Lookup Table >', '< Lookup Table Tag >' )
Marcia
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement