I have a query with a field called TaskSummary. I want that field to be the control source on a text box that I have on a form. The problem is that when there are more than one records, each one is in the text box on a separate page of the form. I need it so if there is say 5 TaskSummary records, all 5 are in the text box on one page. Is this possible and if so, how? Thanks for any help.
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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Text Box Problem
- Thread starter DeeDee
- Start date
- Thread starter
- #3
You can change the size of a list/combo box when clicked upon. It would display it full length.
Can you create a quick button on the form that opens the combo box's table so that the user can add/edit whatever item they want to the pick, but only for that table? If you don't limit the combo box to the list, they could enter items that aren't in the list until you have a chance to add them to the table.
Can you create a quick button on the form that opens the combo box's table so that the user can add/edit whatever item they want to the pick, but only for that table? If you don't limit the combo box to the list, they could enter items that aren't in the list until you have a chance to add them to the table.
dd,
Do I understand you to mean that you want the field data from all 5 records' in *one* textbox? If this is the case, then it *can* be displayed as you want...and even edited...but when it comes to re-writing to the 5 records--where do you 'divide' the single texbox up? Which of the 5 get which chunk of text?
If that's not the case, and you want 5 textboxes from a group of records on a single page, then there are a few ways of doing that. You could use a subform, and group the records in the subform--ie the 5 records in your example are all grouped by some common field (taskSummaryID?), and the subform could be filtered to show that group, with all 5 textboxes there, one on top of the other.
Or, you could use Unboud text boxes, use logic to fetch/fill the data to the textboxes, then in the AfterUpdate of the textboxes you have an sql statement that updates that boxes record. This get's hairy when you consider that you probably want to conditionally enable/show each box, and you may not know how many total textboxes you might end up having--if you could have 500 tasksummary records, this is not feasible--even with 20 it's not--but if 5 +- is your limit, then it would work.
--Jim
Do I understand you to mean that you want the field data from all 5 records' in *one* textbox? If this is the case, then it *can* be displayed as you want...and even edited...but when it comes to re-writing to the 5 records--where do you 'divide' the single texbox up? Which of the 5 get which chunk of text?
If that's not the case, and you want 5 textboxes from a group of records on a single page, then there are a few ways of doing that. You could use a subform, and group the records in the subform--ie the 5 records in your example are all grouped by some common field (taskSummaryID?), and the subform could be filtered to show that group, with all 5 textboxes there, one on top of the other.
Or, you could use Unboud text boxes, use logic to fetch/fill the data to the textboxes, then in the AfterUpdate of the textboxes you have an sql statement that updates that boxes record. This get's hairy when you consider that you probably want to conditionally enable/show each box, and you may not know how many total textboxes you might end up having--if you could have 500 tasksummary records, this is not feasible--even with 20 it's not--but if 5 +- is your limit, then it would work.
--Jim
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question