=Date() - generates todays date.
=IIf([txtage]>=20,"A","B") - generates the age category of the person by using the age field.
=DateDiff("yyyy",[txtdob],Date()) - generates the age of the person by using the dob field.
=[cborun].[column](1) - picks up a column from the combo box in the same form.
=[cborunner].[column](4)+1 - picks up a column from the combo box and adds 1 to it.
=Max([tblruns]![Date])+7 - generates a new run date which is always a week after the previous run.
=Left([cbolocation],2)&Max(Right([tblruns]![RunID],4))+1 - generates a unique run code/id by combining the first three letters from the location with a number that is always one more than the highest in use.
Comments
Report
Report
Report
Report