How do I link unbound controls to the current row in a subform. I am currently trying to create a subform that allows users to enter values into multiply unbound controls in a row in a subform. To save space, I don't want to create a field for each control. I am using a procedure to place the values entered by the user into a table(the procedure works fine). As I enter a value into a unbound control it populates the entire column with that value(undesired).
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Linking Unbound Controls in a Subform to the Current Row
- Thread starter jwilso
- Start date
That is the way subforms and unbounds work. when you set the value for and unbound you are setting it's value on all records. The only way the data is displayed differently is if the data source is different. Setting a value means the datasource is All the same. I don't think the subform is the best option for what your trying. I resolved this issue by using various methods tables, relations, and update querys.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Question
- Locked
- Question