I'm wondering if it's possible to have two text boxes called Date1 and Date2 and these two box will have the value of two separate records in a single view form. I've tried this SQL limit function which limits the rows that i want but it doesn't seem to be working under access. Basically i need the 1st record's date value to be in Date1 textbox and the 2nd record's date value in Date2 textbox. And all these will have to be on one page, so it behaves like a continuous form.
Thanks
Thanks