Blank fields in form

[steven w]

I have three forms linked by JobID. JobID and Job Title
are common to all forms. The master form holds all
information correctly, but when viewing the two linked
forms, Job Title field is blank. There are no error
messages. Thanks for any advice to help with this problem.

 

[MacDermott]

If each JobID has its own title, and both fields are in tblJobs, you could
set the ControlSource for your Job Title field to this:
= DLookup("[Job Title]","tblJobs","JobID=" & [JobID])
(this assumes the JobID is numeric)

HTH
- Turtle

 

[steven w]

JobID is text

-----Original Message-----
If each JobID has its own title, and both fields are in tblJobs, you could
set the ControlSource for your Job Title field to this:
= DLookup("[Job Title]","tblJobs","JobID=" & [JobID])
(this assumes the JobID is numeric)

HTH
- Turtle

I have three forms linked by JobID. JobID and Job Title
are common to all forms. The master form holds all
information correctly, but when viewing the two linked
forms, Job Title field is blank. There are no error
messages. Thanks for any advice to help with this

problem.


.

 

[MacDermott]

= DLookup("[Job Title]","tblJobs","JobID=" & chr(34) & [JobID] & chr(34))

JobID is text

-----Original Message-----
If each JobID has its own title, and both fields are in tblJobs, you could
set the ControlSource for your Job Title field to this:
= DLookup("[Job Title]","tblJobs","JobID=" & [JobID])
(this assumes the JobID is numeric)

HTH
- Turtle

I have three forms linked by JobID. JobID and Job Title
are common to all forms. The master form holds all
information correctly, but when viewing the two linked
forms, Job Title field is blank. There are no error
messages. Thanks for any advice to help with this

problem.


.