Hi, how can I find the number of records and the position of the current record e.g. Record 3 of 12 using the DataControl.
thanks in advance
MICK
Printable View
Hi, how can I find the number of records and the position of the current record e.g. Record 3 of 12 using the DataControl.
thanks in advance
MICK
# of records: dat1.recordset.recordcount
current record: dat1.recordset.bookmark
Have you ever used the Object Browser? If so, ignore this next bit. But, if not....try hitting F2. There you can look at all the properties and methods of all the objects available to the program you are working on. It is WONDERFULLY useful for stuff like this. In this case, you could search for DAO and pull up all the possibilites for it. Then, you would scroll through, looking at the description window until you found the method or property you were looking for.
Hope that helps.
Eva