hi Sarah,
the only way to link Null to Null is for them NOT to be Null ...
put this field in the record source for both forms, and use it in LinkMasterFields and LinkChildFields. Be sure to put a control on each form with this in it too -- control can have Visible=No
Table_: nz([Table],"")
"Table" is a reserved word -- hope this doesn't create issues for you
http://allenbrowne.com/AppIssueBadWord.html#T
have an awesome day,
crystal
free code you can use in your projects
https://msaccessgurus.com/code.htm
connect to me, let's build it together
http://www.msaccessgurus.com
On 8/19/2019 7:00 PM, sarahk@schemesoftware.com [MS_Access_Professionals] wrote:
I have a report that links child / master fields on main report and subreport. there are 2 fields: 'shift' and 'table'. everything works , except when 'table' is blank (legitimate for this entry).Question: how can I link blank table on main from to blank table on subform?.
Thanks for your help
Sarah
__._,_.___
Posted by: crystal 8 <strive4peace2008@yahoo.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar