I would like to know if there is a way to use the expression:

=iif([Order Sent]=yes,date(),null) can work by keep the date as the original date the order was sent, and not keep populating current date as days go by.

This expression is in a text box in a form. The Order Sent is a check box in that same form. They are both fields in the same table. The goal is to check the order sent box and auto populate what day it was sent, and when the product is received, to just uncheck the order sent box, and the date will go away.

Thanks in advance

iif sounds like an Access VBA construct
do you want this question moving to another, hopefully relevant, forums where you are more likely to get an answer

That would be fine. How do I do that?

probably the best way to approach this is to, say, have a button whiuch the user presses to indicate the order is shipped. and attach some code behind that button that sets the ship date, or allows the user to set a shipdate.
then lock the button in futures so users cannot set a new ship date AND cannot edit the ship date

so it comes down to you, do you want to allow your users to set shipping date or do you only want set the ship date based on the current date?

you can lock the button on the basis of the shipping date column
if there is a valid date in shipdate then disable the button. put soem code in the forms on current event. eg:-

this can be rewritten to simplfy the logic
functionally its the same as above but expresses it as a single statement. note you may need to check for null values.

how you handle users addign dates other than today I'll leave up to you. ytou could use a modal dialog, you could use the button to display a date picker control set the default value to today, and set the value of shipping date assuming the user selects a date. if a date is selected then disable the button . you need to work out a strategy to lock the shipping date control so a user cannot edit the date once set

Thanks, I will give it a try.