titorober23
asked on
add new record from subform
Hi Guys
I m going crazy with a simple subform
Main form
IDMain
date
Subform
ID
IDLink
field 1
field 2
relationship 1 to many enforced
I am displaying both forms and link field is IDMain --> IDLink
when i add a record in the subform, it is supposed save it and when i click new record on the main form it should create the id and add that id to the linked field in the subform, but that is not happening.
all other info is created in the subform but the linked field.
what is happening i have done this many times with no issues but now its taking me too long to figure it out what is happening.
Please help
thanks
I m going crazy with a simple subform
Main form
IDMain
date
Subform
ID
IDLink
field 1
field 2
relationship 1 to many enforced
I am displaying both forms and link field is IDMain --> IDLink
when i add a record in the subform, it is supposed save it and when i click new record on the main form it should create the id and add that id to the linked field in the subform, but that is not happening.
all other info is created in the subform but the linked field.
what is happening i have done this many times with no issues but now its taking me too long to figure it out what is happening.
Please help
thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I've requested that this question be deleted for the following reason:
Not enough information to confirm an answer.
Not enough information to confirm an answer.
ASKER