Here's my problem:

I have a table called WorkOrder. I have fields labeled:

JobID, which is an autonumber
WODate, which is formatted as =Date()
and WOID, long integer

Here's what I want to do and have done:

On my form I have WOID control source set to:

=Format([WODate],"mmddyy") & Format([JobID],"00")

I know that storing calculated values isn't the preferred method but it's what I've done.

The problem is I have a cmd button on the form, that when clicked asked for the WOID. This button is based on a query to print a specific work order.

The problems is that this calculated value (WOID) isn't appended to the table so nothing exists when the cmd button is click and the WOID is entered.

How can I update the table with this WOID for the specific job?

Why not just modify your query to look for the same formula you put on the ControlSource of that control and you would not need to store the calculated value.