SET TEXTBOX VALUE TO LAST SAVED VALUE

[Shafique]

Hello Everyone
i want to show in textbox its previous saved record's value
e.g......
ID txtdate
1 19-07-22
2 ID 1 = txtdate (19-07-22)

 

[Shafique]

txtDate = DLookup("PRDDATE", "MDFPRD", "ID = " & DMax("ID", "MDFPRD", "ID < " & Me.ID))

Our posts are crossing. Note that the red/blue parts are associated with each other.

Firstly, I after looking at your table pic I realized that you need a date based based on the ID that is the highest value but is less than the current record ID value.
So post your actual code or see what happens if you put in any valid ID number instead, such as

txtDate = DLookup("PRDDATE", "MDFPRD", "ID = 5"). Also, form must have the ID field on it, otherwise Me.ID will raise an error. If not there, try adding it (you don't have to make it visible). The PK field should always be on a form/report in case it becomes necessary - such as in this case.
EDIT - company coming; not sure how much time I will have for this today.

i tried it another textbox named txtdate.
but i am very sorry to say that it comes with same error

 

[Micron]

I don't know why you're showing that stuff. I said to put the code in the form AfterUpdate event and you're showing things about a query and a button click. Maybe you'll have to post some file somewhere if you can't figure it out. I did test the code at my end and I got the correct value from my table.

 

[Shafique]

txtDate = DLookup("PRDDATE", "MDFPRD", "ID = " & DMax("ID", "MDFPRD", "ID < " & Me.ID))

Our posts are crossing. Note that the red/blue parts are associated with each other.

Firstly, I after looking at your table pic I realized that you need a date based based on the ID that is the highest value but is less than the current record ID value.
So post your actual code or see what happens if you put in any valid ID number instead, such as

txtDate = DLookup("PRDDATE", "MDFPRD", "ID = 5"). Also, form must have the ID field on it, otherwise Me.ID will raise an error. If not there, try adding it (you don't have to make it visible). The PK field should always be on a form/report in case it becomes necessary - such as in this case.
EDIT - company coming; not sure how much time I will have for this today.

I am very very apology due to last night confusion..
you guide me right way but i cannot understand it. its my fault.
your given solution is working correct
thanks a lot

 

[Micron]

Glad to hear you got it working.