Continuous Form Programming Woes

[Question Boy]

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

 

[Mark Grizzle]

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?

 

[Linq Adams via AccessMonster.com]

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.