Datasheet form + extra unbound textbox -> Can you help me with this??

[escoz]

hi everybody!

I'm trying to do something that seems simple:

- One Datasheet form, linked to a database view: Works fine
- One button per line, that should execute a query passing the line ID
when clicked: Works!
- One textbox per line, that displays a "OK" once the button was
clicked - PROBLEM!

It seems easy right? But access is not allowing me to do this. When I
click the button, instead of updating the textbox for the current
line, it updates ALL the textboxes on the Datasheet.

I really have no idea how to fix this. Does anybody knows what can I
do??

Thanks a lot!!

Eduardo Scoz

 

[UpRider]

Escos, the only way this will work is to add a new field to one of the
tables that the form recordsource uses, and bind that field to the OK
textbox.
An unbound control on a datasheet form is only defined ONCE. It just
repeats over and over for each row of bound data.
So, if you change one, you change them all. However, a bound control
belongs with the other bound table DATA in that row.
Make sense?

UpRider

 

[escoz]

Thanks, Uprider! yes, it does make sense, and it's exactly what I'm
seeing here.

Unfortunately, on my problem, the recordsouce is a view of 5 other
tables (with left and inner joins everywhere), and there's no way to
bind it.

I'll see what I can do, I'll likely have to change everything..

Thanks !

Eduardo