Moving records from one table to another via button?

[Dclassen89]

I want to create a form based on a pending orders table that will move a record to a "confirmed orders" table. Both tables will have the same structure im just not sure if this is possible.

[orange]

Why not 1 table and a Yes/No field
eg ConfirmedYN with values
Yes==Confirmed No====Pending

[Dclassen89]

Why not 1 table and a Yes/No field
eg ConfirmedYN with values
Yes==Confirmed No====Pending

Thats what I was thinking in the beginning I will do some testing with that as well. Edit: I think this will work actually I just need to get my form to filter on load to display only record which havent been confirmed with this yes/no selection.

[June7]

Maybe a date/time field would be more informative.

Name it ConfDate.

If there is a date it is confirmed, if there isn't then it's pending.

[Dclassen89]

All im having a problem with is getting the form based on this table to open from another form.

Private Sub Command7_Click()

DoCmd.OpenForm "Pending Sales", , , "Date Confirmed = Date Confirmed Is Null"



End Sub

Button wont work .

[June7]

Field names have spaces. Must enclose in [].

Advise avoid spaces and special characters/punctuation (underscore is exception) in naming convention for all objects.