Hi, I've tried to open a form using a button from a menu form. The button onclick property creates a SQL join (1-1) between 2 of my tables and then sets the recordsource property. The form opens fine but the record selector always shows all records whilst the form is on the 1st record but when I...