Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Hello,

Really not certain as to what is wrong on your end. Attached is a sample (simple - only Company & Contacts) which does allow modifications to the Company records even though it is based upon a query. The query uses a user entered parameter for selection of country (LOCATION field in Company).

If you are still having problems a sample, without personal or confidential information, would be helpful.

Sample - QueryWithSubForm.odb

Hello,

Really not certain as to what is wrong on your end. Attached is a sample (simple - only Company & Contacts) which does allow modifications to the Company records even though it is based upon a query. The query uses a user entered parameter for selection of country (LOCATION field in Company).

If you are still having problems a sample, without personal or confidential information, would be helpful.

Sample - QueryWithSubForm.odb

Edit 2018-05-01:

Your query makes no sense. It creates a company record for each contact in the contact table and therefore creates a temporary table not directly related to the original table.

Company table:

image description

Query result:

image description

Can't understand reasoning for this. It does not change the subform results in any way. In fact it confuses the results. With this query it presents the identical subform information on multiple form records. With this query if there were 100 contacts you would have 100 company records all identical. Why?

Original question pointed to being able to select by country but this makes no sense at all. This type of query will not allow updates to the company table. It's not a one-for-one.