Select Record from Data Sheet (A2k (9.0.4402) SR-1)

Topic

New Reply

Select Record from Data Sheet

A2k (9.0.4402) SR-1

I have a main form (full screen) that opens and positions itself on the last record in the table.

I have a button on the form that opens the same table with a data sheet form showing the last 20 records or so.

I want to be able to click on the Account Number field of the data sheet record and have the system open the main form on the data sheet record selected.

I need the code for the data sheet Account Number double click event to position me on the correct record with the main form..

Thanks, John Graves

Reply | Quote

Replies

Using DAO or ADO? You have the current record in the datasheet, so you can refer to the controls that hold the keys you’re going to want to find on the main form. Then all you have to do is find them in the form’s recordset. If you use DAO, you can use recordsetclone navigation. If you use ADO, you do a find in the form’s recordset.

Reply | Quote