Problem description: I need to load a record based on an alphanumeric primary key field of a table selected from a dropdown combo box. Then, i need a command button that when clicked, will display the record in the approriate text boxes. For example, the user will select a project number (alphanumeric) from a project table using a datacombo box. then, all the text boxes will populate with the appropriate fields from the table. I've tried numerous ways to do this to no avail. I'm a beginner at this so i would appreciate any help i can get. Thanks in advance.