Insert new row in acess form

[553]

I have a main form with employee information. I then have a a subform called cases where the emplid for the main form is linked to the subform by the field complaintee's id. The case no is the primery key (autofill).

In the case that there are more than one case for the employee, I want to be able to add a new case on the subform to the same employee's main form.

 

[belovedcej]

Try experimenting with continuous subforms. They have their pluses and minuses. But for the purpose you are speaking of, it sounds like you might want to try them.

 

[TheAceMan1]

How are ya 553 . . .

[ol][li]Is the relationship between [blue]emplid[/blue] & [blue]complaintee's id[/blue] a [purple]one to many[/purple]?[/li]
[li]If the above is true is your subform properly linked with [blue]Master/Child Link[/blue] properties?[/li]
[li]If 1 and 2 above are true then a [blue]continuous form[/blue] should work just fine . . .[/li][/ol]

See Ya! . . . . . .