Solved Before previous and current value on form

[lacampeona]

Hello experts,
I need some help.
I have a tbl1 and combobox called Status which can contain different statuses.
From my combo box user can choose different statuses for the item; In stock, InUse, Released, Testing,Sended,Out of use, Destroyed.

Lets say user make some borrowing and the statuses where changing from day1 to day...n.........
day1: in stock
day2: in use
day3: in use
day4: relased
day5: sended

the important statues is Released....when the item will once receive ste status released that status must be informed to the user.. user must know that this item was once released and what is the current status of the item?

now i have only one status field and i am wondering if is it possible in some way to show to the user also the current status of the item?
hmmmm like showing two statuses for the user..status 1 and status 2 but I only have one field?

Is it posssible somewhere in the form to make two fields or some message or something to say to the user/ showing to the user status that this item was already relased(from day4) and current state of the the item status: Sended. (in this case this is current status)

I need some ideas how to make that or some example how you experts would resolve that problem.
thanks in advance

 

[theDBguy]

If you're using a form, you can add an unbound textbox and use DLookup() to display the current status.

 

[lacampeona]

Hello
yes for showing only the current status i know how to make it...what about the released status?
that released status is my problem

 

[theDBguy]

Hello
yes for showing only the current status i know how to make it...what about the released status?
that released status is my problem

What do you mean? Are you asking how to know/find out if there is a "released" status? If so, you could also try using DCount() for that.

 

[lacampeona]

ohhhh yessss i am so crazy...yes you are right,,,i have to make the same
thank you

 

[theDBguy]

ohhhh yessss i am so crazy...yes you are right,,,i have to make the same
thank you

You're welcome. Good luck with your project.