Adding a new record in a form 1

[losesoul]

I built a form from a query. When I try to add a new record in the form I get this error message "can't add records, join key of table not in recordset. How do I fix this, so I can add records?

 

[TheAceMan1]

How are ya losesoul . . . . .

It sounds like you didn't include The [blue]PK[/blue] or [blue]FK[/blue] of an existing relationship. Get the query in design view and include one of the above.

Give it a whirl and let us know . . . . .

See Ya! . . . . . .