Using Find Button in Forms Create Duplicate Data

[Jamibollah_abbas95]

Hi there. I have an access call table that will keep data for all the contact that i need to call each day. I use a form to edit the data. and if i want to click specific contact to edit in the forms, i will select the ID column in the forms and use the find function to find the ID. But what im realize is after i find the ID i check the Call table and the data that i find already been duplicate. Is there anything that you guys can help me with this issue? Im new to access and using youtube to learn all the stuff.

[ranman256]

We can't guess not seeing your design, but your form may be wrong.

in the form header ,you need an unbound box to enter the ID.
the after update event will FILTER the records.

me.filter = "[id]=" & txtFind
me.filterOn = true


this will not cause a duplicate.

[Missinglinq]

And the key point here is

...you need an unbound box to enter the ID...

Linq ;0)>