Hi!
Background info:
I put the essential data from tblOrders, tblCustomers in the head
section on a popup form, and the data from tblOrderDetails in the
Detail section. The form is a continous form.
I made a tblReturningOrders that I use as data for the report of this.
It is all being:
DoCmd.RunSQL "DELETE * FROM tblReturningOrders"
DoCmd.RunSQL "INSERT INTO tblReturningOrders SELECT * FROM
qrySendReturn
"WHERE (((OrderNr) = Forms!frmOrders!OrderNr));"
It works fine.
Thanks to Darryll and Ed for superb help.
At the end of tblReturningOrders I put a 'Select'-field (Yes/No). Now
every time a user choose this checkbox on the form I did:
Private Sub chkReturned_Click()
Me.Refresh
End Sub
and only the selected rows will go to the report, since
tblReturningOrders is the source for the report.
Now to another question:
How can I select all checkboxes on the continous form with a
button?
Setting Me!chkReturned.Value = true
will only select the first one.
Do I need a controltype property to cycle through or..?
I also plan to make a copy of tblOrders and tblOrderDetails, in order
to copy the returned order, so that the IRS, when due time comes, will
greet us.
Is this a good procedure or bad programming?
I have a thousand other question, but I don't think You can bear it
all for the moment, so let me threat you nicely in portions :-)
Me.Name