Display one record from multiple records 
Author Message
 Display one record from multiple records

Heres the scoop,

I have a data control on a form, and this form displays an Access record
in a certain format that I have designed (using text boxes, etc) (only
one record at a time).
Searching with FindFirst, based on the records LastName attribute,
displays the result (record).
A problem exists if there are two or more records with the same last
name. FindFirst points to the only one of  the names. If the data is not
sorted, well you know
Anyway, I thought I could create a form that displays a SQL query in a
dbGrid bound control to display all records with the desired LastName,
then click on the name I want out of the query results, and display that
record on the first form.
Well I have done just that, but I have been trying to figure out if a
property exists of the selected record  in the dbGrid (i.e. record
number, bookmark, etc)  that could be transferred to the first forms
data RecordSet (to display this record on the first form). Is this
possible, or have I made any sense at all.

Any help or direction is appreciated,

Phil



Sun, 09 Apr 2000 03:00:00 GMT  
 Display one record from multiple records

Quote:

> Heres the scoop,

> I have a data control on a form, and this form displays an Access record
> in a certain format that I have designed (using text boxes, etc) (only
> one record at a time).
> Searching with FindFirst, based on the records LastName attribute,
> displays the result (record).
> A problem exists if there are two or more records with the same last
> name. FindFirst points to the only one of  the names. If the data is not
> sorted, well you know
> Anyway, I thought I could create a form that displays a SQL query in a
> dbGrid bound control to display all records with the desired LastName,
> then click on the name I want out of the query results, and display that
> record on the first form.
> Well I have done just that, but I have been trying to figure out if a
> property exists of the selected record  in the dbGrid (i.e. record
> number, bookmark, etc)  that could be transferred to the first forms
> data RecordSet (to display this record on the first form). Is this
> possible, or have I made any sense at all.

> Any help or direction is appreciated,

> Phil


Phil,

Don't know if you've had an answer by now but anyway...

Use just one data control.  Then when a record is selected in the grid, that
becomes the current record in the data control that you can display as you
wish.

Hope that helps.
Ian



Sun, 16 Apr 2000 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Need to display multiple lines mini report within one record in a report

2. Display multiple record in one text box

3. How to display one record on one line in a listbox

4. Combine multiple records into one

5. generate multiple records from 1 record

6. Eliminate records of one table based on another table record count

7. Finding Records and Updating Records in More than one Recordsets

8. Two Records In One Record

9. Combine multiple records into one

10. Acc97 - Merging Multiple Records into a Single Record

11. Record navigator and add record all in one???

12. Determining whether a record is a existing record or a new one

 

 
Powered by phpBB® Forum Software