Linked Form Not Allowing New Records
- From: "Rob" <rob.yergovich@xxxxxxxxx>
- Date: 14 Aug 2006 12:58:56 -0700
I have a one to many relationship between two tables: tblCars and
tblParts (One car can have many parts). I created a form using the
wizard and chose "linked forms" instead of "form with subform" when
prompted. The problem Im having is that when entering new records in
the linked form it does not capure the "linked" field from the main
form which causes an error message which reads "Index or primary key
cannot contain a null value". I know access is supposed to "autofill"
that field but its not working. Whats more frustrating is that it
works fine for existing records. I only have a problem during data
entry. Any ideas?
.
- Follow-Ups:
- Re: Linked Form Not Allowing New Records
- From: pietlinden
- Re: Linked Form Not Allowing New Records
- From: Rick Brandt
- Re: Linked Form Not Allowing New Records
- From: Jeff Boyce
- Re: Linked Form Not Allowing New Records
- Prev by Date: Re: how-show different text msg based on value of dlookuo
- Next by Date: Re: Display all columns on a form that are shown in a drop-down bo
- Previous by thread: Vista Oh my god Panic
- Next by thread: Re: Linked Form Not Allowing New Records
- Index(es):