Hello People.
I have a Query with two columns "Num" & "SubjectList" the "Num"
column contains sequential No's starting at 1. This Query is entered into
the Row Source property of a List Box. What I want to do is when my Form is opened the list box will display entries No's 1 to 39 only. If under
the "Num" column in the Criteria row I enter >=1 and <=39 it all works and I get just what I want.
However what I would like to do is call a function
from the "Num" Criteria so that I can use calculated variables and I
cannot get my head round how to do this in code, any help would be appreciated.
I have a Query with two columns "Num" & "SubjectList" the "Num"
column contains sequential No's starting at 1. This Query is entered into
the Row Source property of a List Box. What I want to do is when my Form is opened the list box will display entries No's 1 to 39 only. If under
the "Num" column in the Criteria row I enter >=1 and <=39 it all works and I get just what I want.
However what I would like to do is call a function
from the "Num" Criteria so that I can use calculated variables and I
cannot get my head round how to do this in code, any help would be appreciated.