Recordset is not updateable

[onyris]

Hi guys

I have a little problem

i have a small database with 2 formrs

First form displays all the records and i also have a search button which allow the user to search for a specific record .
When the search buton is clicked then a macro runs wich consists of running the query and displaying the second form with the records found .
The only problem i have is that when the records are displayed i CAN''T modify the fields .
On the macro sttings there is an option when the form is opened to be ( edit mode, addmode , read only mode) and it is set to edit mode but still doesn't allow to modify the fields.

Thanks

[NeoPa]

Check out the query that the form is bound to. You'll probably find that too, is not updatable.

Reasons for a Query to be Non-Updatable.

[onyris]

Thnks for the Link .

I didn't know that if i'm using a union query , then the records are not updateable.

Is there any way around this to make it updateable.

All i'm doing is basically to allow the user to serach for different fields on the same search , if u understand me . ( like i have one textbox to serach for and i want to be able to serach by first name , by city ..etc) .

thanks

[NeoPa]

@onyris
It?

What does this refer to? You haven't posted any SQL for a query.

[onyris]

Sorry i forgot to put the query

this is the query i'am using at the moment

SELECT *
FROM [names]
WHERE (((names.fisrt_name) Like "*" & [forms]![names_form]![txtname] & "*"));
UNION SELECT *
FROM [names]
WHERE (((names.cemetery) Like "*" & [forms]![names_form]![txtname] & "*"));

when i run the query , it returns the record set that i want , but i can display it on the form , but i can't modify it . .

[NeoPa]

Ah, that makes more sense now.

You need just a little work on the WHERE clause instead :

SELECT * 
 
FROM [Names] 
 
WHERE ([First_Name] Like '*' & [Forms]![Names_Form]![txtName] & '*') 
   OR ([Cemetery] Like '*' & [Forms]![Names_Form]![txtName] & '*')

NB. I re-spelled your field name which was mis-spelled.

[onyris]

Thanks a lot , is working now and i can edit the fields .

Thanks again!!

[NeoPa]

You're welcome & I'm very pleased to hear it :)