Hi all. In a nutshell - I'm using an unbound text box on a form to show how many people are under 16 from the related table.
I'm building a customer management system which will hold various bits about the person and their family make up. I already have an unbound text box showing the total household members by using a VBA Dcount in the On Load event of the form.
Code:
Me.txtMembers = DCount("*", "[tblHHmembers]", "[CustID] = " & CustID) + 1 '+1 to add the client on
Can I further this code to then only show the currently under 16's by looking at the DoB from the tblHHmembers ?
It has been suggested to me to use a query. I don't know SQL (still learning vba!) and if I do it with a query, I'd have to use the query builder grid, but don't know where to start with that way either. I just assumed it would be easier in VB?
Cheers!
Jamie.