Resync Command / Unique Table Problems

[flute72080]

I have a form with RecordSouce = "Select * from dbo.Circuits" I have tried to set UniqueTable = Circuits (this appears as an option in the drop-down) and ResyncCommand = "Select * from dbo.Circuits WHERE dbo.Circuits.RecID =?" (where RecID is my primary key). After I set the Unique Table and Resync Command, I save the form and open if in form view.

If I then try to open it in design view again, the values that I entered for Unique Table and Resync Command have cleared out. I am very confused. Do you know what I am doing wrong?

Thanks,
Beth

 

[Nowell]

Hi,

is circuits a view? try just setting the unique table and leave the resync, have you tried compacting and repairing?

Why did you need the resync in the first place?

 

[flute72080]

Hi -

Circuits is a table - sorry I forgot to specify.

Thanks for your suggestions. I just tried compacting & repairing - no luck there. Setting just the unique table command doesn't work either. Once I open the form in form view, the Unique Table value has been cleared out.

I thought I needed the resync command to view the most recent data. My underlying problem is that if I have multiple users working in the database at the same time and one makes a change to a record, the others will not see that change.