G Guest Nov 21, 2007 #1 I have a table for employee vacation dates. How can i get a text box in a form to show only the last vacation date?
I have a table for employee vacation dates. How can i get a text box in a form to show only the last vacation date?
J John W. Vinson Nov 22, 2007 #2 I have a table for employee vacation dates. How can i get a text box in a form to show only the last vacation date? Click to expand... Set its control source to =DMax("[vacationdate]", "[tablename]", "[employeeID] = " & [EmployeeID]) using your own field and table names of course. John W. Vinson [MVP]
I have a table for employee vacation dates. How can i get a text box in a form to show only the last vacation date? Click to expand... Set its control source to =DMax("[vacationdate]", "[tablename]", "[employeeID] = " & [EmployeeID]) using your own field and table names of course. John W. Vinson [MVP]
G Guest Nov 22, 2007 #3 Thanks -- Mr. G. John W. Vinson said: I have a table for employee vacation dates. How can i get a text box in a form to show only the last vacation date? Click to expand... Set its control source to =DMax("[vacationdate]", "[tablename]", "[employeeID] = " & [EmployeeID]) using your own field and table names of course. John W. Vinson [MVP] Click to expand...
Thanks -- Mr. G. John W. Vinson said: I have a table for employee vacation dates. How can i get a text box in a form to show only the last vacation date? Click to expand... Set its control source to =DMax("[vacationdate]", "[tablename]", "[employeeID] = " & [EmployeeID]) using your own field and table names of course. John W. Vinson [MVP] Click to expand...
