list of values problem

[sneha]

I am trying to insert a record in the text field of a form to which an lov is attached and wants that if a value is not present in the list of values and i am myself is entering that value,the list also should get updated with that new value entered.I have kept automatic refresh property to yes.Any ideas....

[stecal]

Insert/Add a row in the record group to add the value. You say to keep the value in the LOV - keep it for how long? Forever? You'll need to update whatever table(s) used in the rg query. Keep it for as long as the form is open? Use a parameter or global variable. Not a good idea if you are talking about adding several values to the LOV.

[sneha]

Thanks,stecal.
This forum is making my life easier.