Passing Data From One Form to Another

[aytee111]

There must be some way of making that record unique?

[CharlieK]

There is. But I need a few more fields to do that. What do you suggest? Should I get all those fields using the code and then query using a combined unique key?

[aytee111]

It depends on what your form1 looks like and what you are trying to accomplish. It sounds as though it would be simpler to requery form1 with the filters set, but only you can determine that. If form1 is only there to display the record that the user selects then it would make sense.

[ssanfu]

Maybe this demo???

There are a lot of other things that can be done/added......... this is just an example.

Don't understand why you are doing things this way, but ........

[CharlieK]

@aytee111: I also want to add and update records using form 01. I will try re-querying and post whether it worked for me.

@ssanfu: Thank you so much for the demo. Why I am doing this is, I want the user to be able to search a record and add it to the main form. So the user can either delete/modify or add a new record using the main form.

Thanks to both of you for helping me out!