Referencing text boxes in a form

[Hasher]

Hi Guys . I have a recordset displayed in a form. Within that form I have added a text box and Button. When I click the button it populates every text box. How do I reference the textbox I want to populate. The text box in the line with the button. I have included a picture to describe my problem. Thanks Paul

[pbaldy]

It would populate that record anyway. I suspect your problem is that the textbox doesn't hane a control source, so all records display the same value.

[Hasher]

Thanks pbaldy I can understand that. But it just uses the input from the field to perform a function. There is no control source it needs to attach to. can I somehow refer the control source to the recordset ID to form some sort of relationship?

[pbaldy]

Well, if you populate an unbound textbox on a continuous form, all records will show the same value as per your image. You can pull a value from a bound control for use in something, but I'm not clear on what you're trying to do.

[Hasher]

Pbaldy . what I'm basically trying to do is move a record from one Job Number to another. So the user enters into the textbox for the record he wants to move , clicks the button and it moves the record. I have the code working for the move. I dont want to store any information about the move . That is why the Text box is unbound. Everything works besides the all the text boxes filling up.

[pbaldy]

An unbound textbox will do that, and to my knowledge you can't stop it. You could use a textbox in the header, or clear the textbox when your process completes so it doesn't distract the user.