Good morning,
I am having trouble with coding a scrolling marquee that would use information that is pulled forward from a query. The query has the following fields:
[Team Name]
[Round]
[Round Pick]
[Player Picked]
[Position]
[Team]
[Overall Pick]
Ideally, what I would like is to have the scrolling marquee display the following:
(QUERY RECORD 1's INFORMATION) "Round" [Round], "Pick" [Round Pick], "Overall Pick" [Overall Pick] - [Team Name] - [Player Picked], [Position], [Team] // (QUERY RECORD 2's INFORMATION) "Round" [Round], "Pick" [Round Pick], "Overall Pick" [Overall Pick] - [Team Name] - [Player Picked], [Position], [Team] and so on...
with real information, it would look like this:
Round 1, Pick 1, Overall Pick 1 - Team 1 Name - Aaron Rodgers, QB, Green Bay Packers // Round 1, Pick 2, Overall Pick 2 - Team 2 Name - Cam Newton, QB, Carolina Panthers // Round 1, Pick 3, Overall Pick 3 - Team 3 Name - Andrew Luck, QB, Indianapolis Colts
I've come up with a code, but it includes a DLookup for every piece of information and it crashes access (as it should because I know that DLookups are completely inefficient).
Any thoughts on how this can be accomplished?
Thank you!