opening selected record in new form (1 Viewer)

rjkimme

Registered User.
Local time
Today, 00:59
Joined
Jul 31, 2001
Messages
15
I am developing in access for my current project but do not pretend to call myself an access programmer. I am a novice with a mission. I have created a switchboard (access 2000) that when a button is pressed brings up the Employee selector form which has a list of the names in my database and the user double clicks on the desired employee. Then the view employee info form is called but come up with all fields blank and an error saying it expected a SQL statement. Anyone know how to get the correcct employee info? The table with all info is called "personnel" the query is called "qryNameList". Thanks in advance and in simple English please. I am not SQL savvy either.
 

Users who are viewing this thread

Top Bottom