Group:  Microsoft Access ยป microsoft.public.access.formscoding
Thread: Continuous Form Programming Woes

Geek News

Continuous Form Programming Woes
Question Boy 12/9/2008 10:35:00 PM
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
Re: Continuous Form Programming Woes
Mark Grizzle <mgrizzle[ at ]oeh.com> 12/10/2008 1:24:13 AM
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

Re: Continuous Form Programming Woes
"Linq Adams via AccessMonster.com" <u28780[ at ]uwe> 12/10/2008 3:43:36 AM
[Quoted Text]
>I have tried various method but when I update the txtbox it updates all the
>entries and not just the one currently being edited?

This is normal behavior for an unbound control in a Continuous or Datasheet
View form! The only way around it is to bind the textbox to a field in your
underlying table.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200812/1

Home | Search | Terms | Imprint Contact
Newsgroups Reader - provided by WiredBox.Net