killerflappy
Registered User.
- Local time
- Today, 20:54
- Joined
- Aug 23, 2017
- Messages
- 50
Hi guys,
I have a report. In this report I show a Routenumber.
This routenr can be variable.
So I thought I make an inputbox in VBA at the open-Event of the report.
Then the inputbox ask for the routenumber, and I can use this variable in the report for Dsum, Dlookup and as tekst. The inputbox ask for the number, but I don't see how to use this variable.
I tried a messagebox right after the input and it shows a "0" every time.
Maybe it's better to do this in a query. I have the routenumber in a query, but I can't use it in the report.
Any suggestions? What is the right way?
I have a report. In this report I show a Routenumber.
This routenr can be variable.
So I thought I make an inputbox in VBA at the open-Event of the report.
Then the inputbox ask for the routenumber, and I can use this variable in the report for Dsum, Dlookup and as tekst. The inputbox ask for the number, but I don't see how to use this variable.
I tried a messagebox right after the input and it shows a "0" every time.
Maybe it's better to do this in a query. I have the routenumber in a query, but I can't use it in the report.
Any suggestions? What is the right way?