I have a table called Main. 3 of the fields are called firstname, lastname and academy. I want to be able to key these in and for Access to retrieve and display all the other fields relating to this unique record in my form. i've tried recordsource using a query but that displays as a datasheet. any suggestions would be helpful. the table contains about 5000 records/rows. thanks