Lost ability to add to a continuous form?

[RSW]

Hello,

I have a database with a huge table on the back-end, and then I want to set up various front-ends that will only show particular records that a user is interested in.

I notice that, when I query the big table without any join, I get all the records and also a space for entering a new record--that's what I want. But, when I add a join that serves to filter the records to the ones the particular user would be interested in, the space for entering a new record goes away. This is the case whether I view the query itself, or the form that uses the query.

Does anyone know how I can keep the ability to add new records while also making the query a bit more complex?

Thanks in advance.

 

[gemma-the-husky]

if yuo asre losing the new item record, the query you are using is probably nonupdateable

open the query directly and try to add an item (or modify an existing item )- you will probably find you cant

search here for "why is my query not updateable" - sorry im not sure how to add these links

 

[GolfProRM]

Go into Access help and search for Troubleshoot Queries - Under the Select query type it explains the situations in which you can update the data (or add new records) in a query.