After Update

Thank you for your reply. I want the date updated in a completely different form. This video updates it on the same form. Can you help me with the VBA code? So if I click TBO box in one form, the date needs to be updated to today’s date in a different form. Thanks in advance.

Value From a Form

Is the other Form open?

No. The other form is not open.

The other form needs to be open BEFORE you can set a value.

You can open the form first then set the value, or if this is a value in another Table you could set the value with some SQL.

That form is opened by my assistant to place the order. If I am opening the form then I can put the date myself. I want to be able to check a box on my admin form which results in a date in the assistants form when he opens it. Is there a way to do that?

Is it just the current date you want? In that case you can set a Default Value for the field.

    =Date()

I want to be able to check a box on my form which will trigger the date on the assistant’s form. So my form will have a check box called TBO (To be ordered). I will check that box and I want the current date to appear on the assistants form so he can place the order. His form is not open when I check my box. Is there a way to do this? Sorry for multiple posts, but I am looking for this specific process. I am in no way a developer or even an access expert. I am in audiology and have made my database from learning here. It works ok but am trying to improve it as much as I can. Any guidance will be appreciated.

I guess this cannot be done. Thank you for your answers.

I wouldn't give up so quickly.  Access is quite powerful and most things can be done.  As I was reading your request for help, I was imagining a possible solution, but not the scenario that you specified.  One possible design would have the check mark on your form.  On the assistant's form, they would have all the necessary information, plus an entry for the completed/ordered date.  When the assistant has completed the order, the date field would be entered.
For the assistant, they could have a Main Menu, with a subForm attached.  On the subForm you could have a listing of all hearing aids that need to be order (looking for the check box from your form) AND blank completed/ordered dates from the assistant's form.  Have that subForm refreshes every-so-often, e.g. every 1/2 hr, every hr, etc.  
Again, the above is only one possible solution. I'm sure there are more elegant was to arrive at the solution which would meet your needs.

Thank you for this. I am not that good with access to envision and make this. I am going to stick to my usual routine of entering the date on his form. Truly appreciate you.

I'm a little unsure as to what you're trying to do. Maybe you could walk us through it step by step. I'm envisioning my database. Let's say I have a customer, and a customer has an order. So, you basically want a checkbox on the order form that, when you check it, fills in today's date. Then, you close it, and your assistant, in his database, can see a list of stuff that he needs to order. Is that what I'm getting from you? Walk us through it step by step, if you can. If you have some screenshots of what you think you want it to look like, post those. Even if you have to mock them up in Excel, it helps if we can visualize it.

If I am close to what you're looking for, you'll need a yes/no field called ReadyToOrder and then a ReadyToOrderDate. You'll put an AfterUpdate event on that checkbox to set the date. Your assistant will then need a continuous form where he can see all of the orders that are "ready to order" and maybe add another checkbox for him (with a date) that's something like OrderPlaced / OrderPlacedDate. This way you can now track what he's done and which items have been ordered.

Am I in the ballpark here?

That’s exactly what I did. It works great. Thank you Richard. You are the best.

I've had something similar to this on my list for a TechHelp video for a while now, so maybe the next week or two I'll put something together. You can see how I would do something like this in depth.