How to get last entered value in text box

[hrdpgajjar]

Hi,
I've a table named inward & a column named inward number

Now, For each time I enter inward number manually. So I want to know what was the last inward number I've entered in a Separate text box to avoid duplicate entry.

- I've tried "DLookup" & DLast query functions but no luck.


kindly help me how can i do that


Thanks

 

[theDBguy]

Hi. I usually use DCount(). Can you show us your code?

 

[isladogs]

Assuming the numbers always increase, just populate it using

Me.txtLastInwardNumber=DMax("InwardNumber", "YourTableName")

Or if you can't rely on DMax, save the last entered value as a variable and retrieve the variable value for your textbox.

Of course a simpler system would be to use an auto number for the field!

 

[hrdpgajjar]

Assuming the numbers always increase, just populate it using

Me.txtLastInwardNumber=DMax("InwardNumber", "YourTableName")

Or if you can't rely on DMax, save the last entered value as a variable and retrieve the variable value for your textbox.

Of course a simpler system would be to use an auto number for the field!

Thanks

works like a charm!!!

 

[isladogs]

You're welcome.
Which method did you use?