Results 1 to 2 of 2
2001-12-03, 21:05 #1
- Join Date
- Jun 2001
- Niagara Falls, New York, USA
- Thanked 0 Times in 0 Posts
Select Record from Data Sheet (A2k (9.0.4402) SR-1)
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
2001-12-03, 21:27 #2
- Join Date
- Dec 2000
- Sacramento, California, USA
- Thanked 1 Time in 1 Post
Re: Select Record from Data Sheet (A2k (9.0.4402) SR-1)
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.Charlotte