Need Help in Retrieving a Specific Record 
Author Message
 Need Help in Retrieving a Specific Record

I have read an entire recordset into a combo list box. Now I need the
click event to make the selected record the current record. The
primary keys can be extracted from data in the list box.

I have posted this before and every has said "Just select the record
based on the primary key and it is now the current record" I know
*what* I must do, just cant quite put together *how* to do it. The
manual examples only cover MoveFirst, MoveLast, MoveNext etc. Help on
topic Select shows SQL queries that somehow have to be put on the
Database but I cant see it. Can someone help with statement fragments?

I am on VB 3.0, Standard. The Unique Primary keys are "COMPANY"
"ADDRESS" and "LOCATION"

Any help would really be appreciated. If you choose to respond via
Email, remove the "***" from the address.

Thanks



Mon, 22 Nov 1999 03:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Counting specific records to SQL table ( Need Help!!)

2. How can i retrieve specific number of records ???

3. Need help with Select statement syntax to retrieve Access2000 record between two dates

4. Need help with Select statement syntax to retrieve Access2000 record between two dates

5. Need help counting number of records retrieved from an Access file

6. HELP: Selecting a Specific number of Records from Record Set

7. HELP: Selecting a Specific number of Records from Record Set

8. Help using OPENXML to retrieve specific elements for use in SQL insert (SQL*Server 2000)

9. Help: retrieve LAST record on database of 50.000 record

10. Get X records before and Y records after a specific record

11. Need to return records in a specific order..

12. Previous and Next record surrounding one specific record


 
Powered by phpBB® Forum Software