Select Record from combo box, the other question

bbwolff

Registered User.
Local time
Today, 15:53
Joined
Oct 1, 2013
Messages
116
I have a form where in the header i select record by selecting person by name, surname, date o birth. In the end there might be a thousand records per year.
This part works well.

Now I'd like to add a few checkboxes, that would limit the records range.
A checkbox that would only select children, Int(([bolnik]![DatumVpisa]-[bolnik]![DatumRojstva])/365,25)<15
a checkbox that would only select women etc, only those that have one or the other thing.
Is that possible?

I guess i'd have to put some kind of iff sentence - iff checkbox is true then only display records with this and this
But where?
sql of the combobox is like this

Code:
SELECT all.ID, [surname] & " " & [name] & ", " & [DateBirth] AS Expr1, all.surname, all.name, all.DateBirth, all.[popis - travma]
FROM all
ORDER BY all.surname, all.name, all.DateBirth;
 

Users who are viewing this thread

Back
Top Bottom