Okay, I need to generate a single record report based on a field's data.
Here is my logic for what I need. I think I have the logic, I just don't know how to translate it. Any help would be greatly appreciated.
User clicks a button to print the member's ID card.
lastly, I have created the queries that generate the reports I want BUT it generates it for ALL my members that have type 1. How do I get it to work for JUST the current record I'm working with?OnClick
IF [membership_type] = 1
open the report for BASIC MEMBER ID
else
[membership_type] = 2
open the report for VIP MEMBER ID
elseif
messagebox = "No Membership Found"
endif