
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: