noobie question that ive been struggling with

[ogg13]

Is there any clear cut way to directly access a cell in a table via code?

Ive looked as far as my eye can look to try and find something quick and easy that allows me to cherry pick data out of a table, but ive had no luck.

For instance, I have a table named tblSANConnections with a field in it named fldServername.

I want a command button to go into tblSANConnections and snag information from fldServername of the current record displayed on my form, and hell, I dont know put it into a variable.

Can someone toss out a few key codewords that I can lookup to accomplish what im after? thank you

 

[Moniker]

Three keywords to search on:

DLookup
SQL SELECT Statement
ControlSource

 

[ogg13]

Thank you! I had just noticed people using dlookup in examples here and figured it might be of some import.