Unable to Add records to Sub From

[Robert M]

For some reason, I am unable to add records to my sub form
I have a two tables
tbl Address
tbl Clients
I have many clients to a single address
"Master" tblAddress.AddID (primary key) to "Child" tblClients.AddNumm (normal field)
Both are "Number" style

I have tried "Data Entry" "Single Form" "Continous Form" and "DataSheet"

I even opened the sub form only and was unable to add records.

What am I missing here?

Thank you for your time and help with this matter.

Robert M

 

[deputy herb]

I'm assuming there is a relationship between the primary key and the foreign key. Did you check that things like enabled, allow edits, allow additions are all set to true? My guess is that it's with the RecordSource property of the subform. Is the database small enough to attach?

 

[Robert M]

Clients has 4692 Records and Address has 3645 Records.
The relationship between the Primary and Foreign key is the number both have.
I do have Filters, Edits, Deletions and Addittions all set to Yes. Data Entry set to no, but that did not make any difference when I set it to yes.
Here is the Record Source Property. If it helps
SELECT
tblClients.ClientID,
tblClients.NameSearch,
tblClients.[Client Name],
tblClients.[Client Name 2],
tblClients.[Acquired Date],
tblClients.[Dropped Date],
tblPartners.PrtnrID,
tblPartners.PrtnrName,
tblBillers.BNID,
tblBillers.BillerName,
tblClients.AddNumm
FROM
tblPartners
INNER JOIN
(tblBillers
INNER JOIN
tblClients
ON
tblBillers.BNID=tblClients.Biller)
ON
tblPartners.PrtnrID=tblClients.Ptr;

I have yet to fully understand the inner/outer joins and join on features so I can't help much on that.

Thanks for your input with this project.

Robert M

 

[boblarson]

The record source for a form really, in most cases, should only be using ONE table for its record source (a query with just that one table is preferred so it can be ordered). Each form would have the table that it needs to update and you don't include tables which you need to lookup values because you use a combo box for those and the combo's row source uses those lookup values and then can display what the translated value from the ID is.

 

[Robert M]

Thanks boblarson for helping me out once again. Took me a few read throughs to get the idea. But I believe you are saying one table/Query for form. other table/querry needed I would use a Combo box to load the data.
Ok, I might have muddled it up in trying to relay what I am needing but I'm sure I know what you mean.

Thanks again, I'll restart with a fresh form with combo boxes where needed then attach the subform. Using a straight from table query.

Robert M