[AccessD] Form Sub form Problem

Colby, John JColby at dispec.com
Fri Nov 19 10:49:39 CST 2004


Many years ago I bought a library of functions for Turbo Pascal (I believe)
- the person who wrote it had the title(s) President and Chief Bottle
Washer.

John W. Colby
The DIS Database Guy


-----Original Message-----
From: Charlotte Foust [mailto:cfoust at infostatsystems.com]
Sent: Friday, November 19, 2004 11:39 AM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Form Sub form Problem


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 

 

-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list