Desperate HELP needed on Main & Subform question !

[ym2004]

Desperately Seeking Help !

I have a Form and within it is a Subform.

Form has a textbox to enter a date. Code will accept the date entry and query if it exists.

If it exists, get all its associated data and display in Subform for user to edit and add more child records.

If it does not exist, then create new Parent record, make the Subform available for user to add child records.

Sounds easy but I am having nightmare trying to get it working together.

My zip file size is 204K, unable to attach file here. Let me know if you need it for better reference, I can mail it to you.

Thanks in advance for any help.

 

[Štef1]

Hello ym2004!
Look at "DemoSubDateA97.mdb"

 

[aleb]

This is how I do it ...
In the properties of the subform find two fields: Link master fields, Link child fields ....

On the "Link child fields" : YourFirstLinkField; YourDatefieldonasubform
On the "Link master fields: YourFirstLinkField; YourDatefieldonmainform


Like on the example attached

 

[ym2004]

Thank you so much for responding, makes my Friday morning a little better now ... I will look at the samples right away.