I have a report with two subforms that have distinct ID numbers. I want to seperate the ID numbers from the subform and place them in the main form. The ID numbers exist in seperate tables. Is there a way to either do this, or use a query to populate the text box/label?
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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
using table field to populate report box
- Thread starter jwrocko
- Start date
Make a text box on the main report, put
=[SubFormNameHere]![IDFieldNameHere]
do that for each of the ID's. It will put the selected record ID in the text box.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at
=[SubFormNameHere]![IDFieldNameHere]
do that for each of the ID's. It will put the selected record ID in the text box.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
- Locked
- Question