GoodyGoody
Registered User.
- Local time
- Today, 14:26
- Joined
- Aug 31, 2019
- Messages
- 120
Hi, I have a really simple issue but can't figure it out. I have a table with a Race ID in it and I want to use this ID to get the race name and date and put them as the header on the report 'cos all results relate to this race. Simples! If I use a text box I just have a field in the underlying recordsource or an expression relating to it but can't do a table lookup. If I use a list or combo box, it still requests a record source and then in the Row source I can put a SQL expression but I don't know how to connect the output of the row source SQL expression to the Control Source. Does that make sense? Say my race event ID is 62. I want to look up the race name and date and display those as the header on the report rather than the number but can't work it out. Help please! Thanks Stephen