I'm quite a newbie when it comes to creating access databases. I've used the basic contacts template Microsoft has used and altered that to suit my needs. I've been trying to create a method of this database automatically showing people on different reports.
On the Contact Details form, I have a subform that shows 6 columns consisting of different venues (for example: Sports Centre, Sportspark, etc.). These 6 columns are comboboxes that house these venues.
What I also have is about 10 reports that I need working as registers, for attendance, for different venues. These registers should show the people who attend certain venues and it should populate. For example, if someone attends "Sports Centre", their name should appear on the Sports Centre report.
However, at the moment, I cannot get it to work. I've tried using queries, tried vba and even Macros. But no success. In the end, it just adds every person on every report.
Can anyone suggest any ideas for what I could try next? If any extra information is needed, I'll try the best that I can to help.
On the Contact Details form, I have a subform that shows 6 columns consisting of different venues (for example: Sports Centre, Sportspark, etc.). These 6 columns are comboboxes that house these venues.
What I also have is about 10 reports that I need working as registers, for attendance, for different venues. These registers should show the people who attend certain venues and it should populate. For example, if someone attends "Sports Centre", their name should appear on the Sports Centre report.
However, at the moment, I cannot get it to work. I've tried using queries, tried vba and even Macros. But no success. In the end, it just adds every person on every report.
Can anyone suggest any ideas for what I could try next? If any extra information is needed, I'll try the best that I can to help.