Desperate HELP needed on Main & Subform question !

ym2004

Midnite Oil
Local time
Yesterday, 21:53
Joined
Sep 23, 2004
Messages
9
:o 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.
 
Last edited:
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
 

Attachments

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

Users who are viewing this thread

Back
Top Bottom