Joe Hecht
jmhla at earthlink.net
Mon Nov 29 13:10:13 CST 2004
If Me.JobTitleID Is Null Then 'If row is blank do nothing
Else
Me.cboJob_Title.Value = Me.cboJob_Title.Column(1) 'Display
job title
End If
Rowsource =
SELECT [Job Title].JobTitleID, [Job Title].JobTitle
FROM [Job Title]
ORDER BY [Job Title].JobTitle;
JOE HECHT
LOS ANGELES CA
jmhla at earthlink.net