J
jkendrick75
i have a child form that automatically populates an AutoID text box as soon
as the user enters data into the parent form. the child form has a command
button on it to save any data entered and then go to the defcode text box for
more data. what i want is for the command button on the parent form to
automatically save a '0' into the two fields in the parent form. i also need
to come up with some way of going through the records that are already in the
table that the child form is linked to and add in records with a '0' in them
where there is a ID number from the table the parent form is tied to, but
there is no record in the child forms table. these two tables are linked on
the ID field. right now there is a 1 to many relationship between the 2
tables, so the second table does not have a record for every ID from the
first table.
as the user enters data into the parent form. the child form has a command
button on it to save any data entered and then go to the defcode text box for
more data. what i want is for the command button on the parent form to
automatically save a '0' into the two fields in the parent form. i also need
to come up with some way of going through the records that are already in the
table that the child form is linked to and add in records with a '0' in them
where there is a ID number from the table the parent form is tied to, but
there is no record in the child forms table. these two tables are linked on
the ID field. right now there is a 1 to many relationship between the 2
tables, so the second table does not have a record for every ID from the
first table.