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

E

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
 
U

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
 
E

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
 
Top