Form / Query question - Can't update?

[janthony]

I'm not sure if this is a form or a query question...

So, I have a Form based of on a query.



The query contains:
From Customer table: Customer name -> Where Like "*" & [Forms]![Menu]![CName] & "*"
From Employee table: Employee name -> Where Like "*" & [Forms]![Menu]![EName] & "*"
etc.
It also contains the main Sales Transaction info, like Customer ID (foreign key), Employee ID (foreign key).

When designing the form, I also added the Subtransactions info (which created a Subform) which contains:
Product Name
Product Price
Quantity
etc.

The form does display Sales Transaction information and filters the information as intended (i.e. by Customer, Employee).

However, using the form I can't update the main Sales Transaction info. The Customer ID, Employee ID, etc. fields have dropdowns like I would be able too, but Access is giving me error in the status bar: The Recordset is not updateable.

I had this same form that worked properly (i.e. allowed updating of Customer ID, Employee ID) but without the query. So I'm thinking this is a query issue? -_- I just needed a way to allow users to filter the listing somehow, since going through thousands of Sales Transactions probably wouldn't be fun.

Basically, what I am looking to do is allow users to search for Sales Transactions (which also shows the Subtransactions) based on query parameters like Customer, Employee, Date, etc. Is there anything I'm missing or is there any other way to go about this? I feel like I'm really close but so far!

[pbaldy]

Probably the query:

http://allenbrowne.com/ser-61.html

I would imagine the form's source shouldn't contain those tables, just the combo row sources.

[janthony]

That stuff is way over my head -_- I tried doing some of the stuff it said in there but no luck. Any other suggestions for how I can do this?

[pbaldy]

You mean other than

the form's source shouldn't contain those tables, just the combo row sources.