Blank fields in form

  • Thread starter Thread starter steven w
  • Start date Start date
S

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.
 
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
 
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

steven w said:
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
Click to expand...
problem.


.
Click to expand...
 
= DLookup("[Job Title]","tblJobs","JobID=" & chr(34) & [JobID] & chr(34))

steven w said:
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

steven w said:
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
Click to expand...
problem.


.
Click to expand...
Click to expand...
 
Back
Top