Edit Form

[wasim_sono]

Dear All
I created a search form based on a query. Two fields of query get criteria values from another form called 'criteria form' which accept values thru user by two unbounded combo boxes. It works fine but the problem is that I called this form as 'edit form'; so the data fetched by this form should be edited but it can't.
What should i do for this? This form is a copy of 'data entry form' which accept the values and also based on same query of 'edit form' except the two fields which get criteria from 'criteria form'.

Please help.:banghead:

Thanks.

Wasim

[wasim_sono]

Dear All

Please solve the query I'm still waiting.

Thanks.

Wasim

[OBP]

wasim, you will need to post an example for us to understand what is wrong with the Query, for some reason it has produced a Non Updatable Recordset.
It might be due to the relationships in the query if more than one table is involved.

[wasim_sono]

Dear OBP

The query has three tables and have field from three tables. This query is same as query for 'Data entry Form'.

The snap shot of query is attached. If required mdb then please give me email address so I forward u my mdb.

Thanks.

Wasim