I have 3 unbound controls in the header of a form. i have the recordsource property of the form which selects * from the underlying table where each of the 3 controls equals the 3 fields in my table. the SQL is correct and this displays in a dataset. however I need the form to display all the fields on the form. I've got a button on the form which I'd like to click in order to get the fields displayed. I've tried Refresh and Requery etc but nothing works.
I know this can be done and I think I'm missing something obvious. can someone please give me a line by line plan of action please?
thanks