Button on form to add a record to a non-linked table

[snipe]

Hey guys,

I have a form that lists order with some of their info. When a process is complete in an outside system, the user presses the button on that record in the form. This button needs to add a record to a separate table, called "T_Invoiced". The record is merely the order number (which is on the same form as the button) and an "X" in the column called "Invoiced".

What is the code to accomplish this?

[JamesDeckert]

docmd.runsql "INSERT INTO T_Invoiced ( OrderID, Invoiced ) SELECT " & me.[field] & " AS txtOrderID, x AS inv"

[snipe]

Thanks James. Tweaked that SQL line a bit and it works great.

Next part is when that Invoiced button is clicked, I want that record to disappear. The form is built on a query that pulls records where [Invoiced] is null. I added a me.Refresh after the sql string and that didn't work. Going into design view of the form and then back to form view, the record does disappear, so the SQL and query works. Why isn't me.refresh working? What should I be doing?

[ssanfu]

Instead of Me.Refresh, you might try Me.Requery.

From Help:
Refresh shows only changes made to records in the current set. Since the Refresh method doesn't actually requery the database, the current set won't include records that have been added or exclude records that have been deleted since the database was last requeried. Nor will it exclude records that no longer satisfy the criteria of the query or filter. To requery the database, use the Requery method. When the record source for a form is requeried, the current set of records will accurately reflect all data in the record source.

[snipe]

Gah I tried Recalc. Didn't even know about Requery. Works like a charm now.

Thanks!