Unique Table

[nirs]

hi
i working on a access project (adp file).
i have a form that based on a table.
when the user wants to filter the recordset he pres a button
and then i change the recordset to a view that based on the same table (filterd), the probleam that when i do that the recordset is not updatable.
here is the code

Me.RecordSource = "FF_V"
Me.Recalc

Me.ResyncCommand = "select * from batch_t"
Me.UniqueTable = "batch_t"

FF_V is a view that based on batch_t
when i run this code i get an error "the setting you entered
isn't valid for this propert" in Me.UniqueTable = "batch_t"


thank you

 

[neecie]

Did you try setting the Unique table before calling the ResyncCommand?

 

[nirs]

yes i did
i think that i have another problem because i can't chose the unique table also in the design view
the only option that i have is the view name
may be there is something wrong in my view???

 

[neecie]

I created a form from a view made with 5 tables and had the same problem.

To fix it, I opened the view, copied the sql text and pasted it into the forms recordsource (replacing the name of the view).

As soon as I did, the 5 tables were available to select in the unique table property.

Good luck!
neecie