GregMiller
Registered User.
- Local time
- Yesterday, 17:45
- Joined
- Dec 5, 2019
- Messages
- 18
I am trying to use a combobox in a form to allow the user to select from a list of activities and then by clicking a button on the same form to produce a report about the receipts and expenditure for that activity. The value from the combobox is stored in a table which is then used to select records using the where statement in the total line of a query. The result I am getting is that the report about receipts and expenditure is produced not for the activity selected by the user but for the activity that happened to be shown in the combobox when the form was opened. So it looks as though the value stored in the table is the value when the form is opened rather than the value subsequently selected by the user. Obviously I am doing something wrong but I can’t work out what.
I would be grateful for any help. As this is my first cry for help I am not sure what further information is needed to solve my problem but if a screenshot of something would help please let me know.
I would be grateful for any help. As this is my first cry for help I am not sure what further information is needed to solve my problem but if a screenshot of something would help please let me know.