please help if you can.
I have a form called exceptions based on a table called exceptions. For each exception there is a single form. Also on the form is a search box. The user tpes in part of a word displayed on the exceptions form in the search box and the seach box queries another table (calpers) and displays the results on a new pop up form.
The query work by saying :look up *calpers form txt value *.Unfortuantly the text on the exceptions form is not allways the value that is the calpers table so that is why only part of the word is used.
What i want to do is pick something from the calpers form and update the exception form with certain values. when I try the code
txtCtpyNamePicked.Value = Forms![Form - Exceptions]![SecurityName].Value
it gives me the error . the recordset is not updateable.
I can use a subform as there is no common link between both. ie only part of the word on the exceptions form matchs part of the word on the calpers form.
Has anyone got any sugestions please as im stumpted.
Much appreciated if anyone can help
I have a form called exceptions based on a table called exceptions. For each exception there is a single form. Also on the form is a search box. The user tpes in part of a word displayed on the exceptions form in the search box and the seach box queries another table (calpers) and displays the results on a new pop up form.
The query work by saying :look up *calpers form txt value *.Unfortuantly the text on the exceptions form is not allways the value that is the calpers table so that is why only part of the word is used.
What i want to do is pick something from the calpers form and update the exception form with certain values. when I try the code
txtCtpyNamePicked.Value = Forms![Form - Exceptions]![SecurityName].Value
it gives me the error . the recordset is not updateable.
I can use a subform as there is no common link between both. ie only part of the word on the exceptions form matchs part of the word on the calpers form.
Has anyone got any sugestions please as im stumpted.
Much appreciated if anyone can help
