
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