I think this is a known behavior of Access. If I remember right, you can get around it by using the cbo's after update event to update the specific record, then refresh the form, and display the current record using a saved bookmark.
Can you consider redesigning the form to show one record at a time?
On 12/9/08 5:35 PM, in article 1539C73A-8039-48BC-BF73-2186295BDC14[ at ]microsoft.com, "Question Boy" <QuestionBoy[ at ]discussions.microsoft.com> wrote:
[Quoted Text] > I have a continuous form in which I have a bound cbo which I use to select > the Proj Number. After the Proj is selected I need a secondary texbox to > display the ProjName. > > I have tried various method but when I update the txtbox it updates all the > entries and not just the one currently being edited? I can get the info I > need but cannot get it accross to the user properly. How can i only > display/update the current record? > > QB
|