cannot find a record in the table with key matching fields

[Suzie2012]

im creating an invoice i have a section that when i select a customer i want it to populate their member info, If they are a member. If they are not it can show nothing. at the moment i have fields on the form to show their membership. when i select a customer that is a member everything works great. but if i select a non member i get the message "cannot find a record in the table with key matching fields"

anyone have any suggestions of how i can make it work like i need it to. How ever its created i need to be able to see member info whether its controls, subform, or pop up box, when a customers is selected.

Im using macros, not VB

[June7]

We need to see code and viewing the form in design would be helpful. Code really should not be needed to accomplish this. If you want to provide project for analysis, follow instructions at bottom of my post.

[Suzie2012]

at the moment that particular function doesnt have code on it

[Suzie2012]

here is a copy of the db

[June7]

From what I can see in that image, I don't understand why you would get error message. The membership info is a subform and Master/Child Links properties should synchronize records. If there isn't a child record the membership info should just be blank. I just might have to analyse database directly so I can view tables, form properties, and test form behavior.

[Suzie2012]

Izzy M and Sophia M are not members, so you dont have to go through em all

[June7]

What? Did you intend to attach file to last post?

[Suzie2012]

i attached one a post up, right before you said u might have to analyse the db

[June7]

Did not see that post as I was composing mine. Must have something to do with youth baseball. I umpire Little League.

The Invoice form RecordSource includes Membership table with an INNER join. This restricts records to those that have Player ID in both tables. Remove that table from the RecordSource. The other joins in the RecordSource are also INNER and should work but could change to 'show all records from Invoices ..."

The ParentID combobox is locked. Change this to a textbox. To show the parent name, include the name fields from Parents in the form's RecordSource and bind textbox to LastName field. Could even create a field in the RecordSource with an expression that concatenates the name fields and bind to that constructed field.
Parent: ParentLastName & ", " & ParentFirstName

Set TabStop No on the Parent name and phone number textboxes. I like to make non-entry controls appear different from editable controls, usually a transparent backstyle.

You have set Lookup properties at table level. Advanced developers shun this because when viewing tables we want to see real values. And since users are not viewing tables and queries directly, the Lookup is not needed for their convenience. http://dbageek.blogspot.com/2004/10/...fields-in.html