Two text box with two different records

[strikeuk]

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.

I can't really use continuous form because i can't set individual properties on different rows of fields. Here's my thread about it Here

 

[llkhoutx]

Certainly.

Store the prior date in the textbox date1 tag property on the before or after update event.

Then on the oncurrent event, store the textbox date1 in textbox2,

That ought to get you started.