[MS_AccessPros] Re: link child/master field on subreport

 

Thank you, was able to resolve this.

Sarah

BTW Crystal: TABLE was a typo on my part, its actually PTABLE

---In MS_Access_Professionals@yahoogroups.com, <graham@...> wrote :

Hi Sarah

As you've discovered, you cannot link two fields when they are both Null, because technically Null does not equal Null - the relationship between them is undefined.

However, you can use the Nz() function to convert the Null to something else - even a zero-length string (ZLS) - for the purpose of matching.

(I understand "table" is the master field and "shift" is the child field, right?  If it's the other way around, just switch the names below.)

On your main form, add a hidden textbox named txtTableLink with 

ControlSource: =Nz([table],"")

To the RecordSource query of your subform, add a field: 

txtTableLink: Nz([shift],"")

If your RecordSource is a table, then create a query based on that table with this additional field.

Now set both the LinkMasterFields and LinkChildFields properties of the subform to txtTableLink

(Note that LinkMasterFields can be a field OR a control, but LinkChildFields must be a field - hence the need to add it to the RecordSource.

Best wishes,

Graham [Access MVP 1996-2016]

__._,_.___

---

Posted by: sarahk@schemesoftware.com

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (4)

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___