Locating Specific Record

[leontro]

Hi All,

I am using an Access 97 database and ADO for modifying records. I have a multiple inner join query. When I add a record to the recordset of the this query, I add only some of the fields of the recordset and requery the recordset to show the related fields of record by Requery method.

Now here is the problem. I want to view the record that is just added but because the Requery method, bookmarking of the record isn't working. I can't use Find method because my criteria needs two columns for location and I don't want to use Seek method because by curserlocation is on the client side not server side.

What can I do for this problem?

Thanks for all replies

[Vit]

First of all, after adding or updating record with ADO the pointer stays at the affected record, so that you can read back its ID (in case it exists).
And besides, what's the problem to use FIND with criteria of 2 or n fields?

[leontro]

Thanks Vit,

Sure my recordset has id, but the problem is that it has two ids and I suppose that FIND method allows only one criteria for finding specific record so it may not work with this method...

Any other ideas please...

[jess]

Hi Loentro,
I'm having the same problem right now as you were describing. What did you end up doing?

Hope you remember and will share your experiance.
Thanks,

[leontro]

Hi Jess,

Unfortunately, I couldn't do anything about it right now but if i have some solution sure i inform you about it...

Good Luck