Simple. But I'm missing something. Please help correct my code. I have Ole1 object control on the form. Here is my code so far;
sSQL1 = "SELECT * FROM Employees WHERE Employees.fkAlpha = " + "'" + Me.FkAlpha2 + "'"
Set DB = OpenDatabase("c:\employees.mdb")
Set rst = DB.OpenRecordset(sSQL1)
The record is being selected properly. rst!Name does display.