[AccessD] Form Sub form Problem

Charlotte Foust cfoust at infostatsystems.com
Fri Nov 19 10:39:23 CST 2004


Are they paying them many salaries as well?  Unless they're storing a
job history, many titles doesn't make sense to me.

Charlotte Foust


-----Original Message-----
From: Joe Hecht [mailto:jmhla at earthlink.net] 
Sent: Thursday, November 18, 2004 11:11 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Form Sub form Problem


The Situation

On an inherited database the client has a single Employees form that
lists the with a text box for job title.

They want to have one employee with many job titles. I am trying to add
a sub form continuous view with a combo box.

 

 

SELECT stblEmpJobTitle.EmpID, stblEmpJobTitle.JobTitleID, [Job
Title].JobTitle

FROM [Job Title] LEFT JOIN stblEmpJobTitle ON [Job Title].JobTitleID =
stblEmpJobTitle.JobTitleID

WHERE (((stblEmpJobTitle.EmpID)=[Forms]![Employees]![EmpID]));

I need to not only show current job title but also assign new ones. When
I go to the next combo box it already has the existing job.

 

Looking for some help here please. 

 

JOE HECHT

LOS ANGELES CA 

jmhla at earthlink.net 

 




More information about the AccessD mailing list