Accessing Data from tables

[Jengo]

How can I access data from a table using this method:<br><br>Dim dbs As Database<br>Dim tdf As TableDef<br>Dim fld As Field<br><br>DoEvents<br>Set dbs = CurrentDb()<br>Set tdf = dbs.TableDefs(&quot;Employee Table&quot<br>tdf.Fields?????<br><br>For example how can I get the 5th cell of the third row?<br>

 

[famousb]

have you tried the DLookup function?<br>this gives you the ability to look up a certain field with within certain criteria. <p>Brian Famous<br><a href=mailto:bfamous@ncdoi.net>bfamous@ncdoi.net</a><br><a href= > </a><br>