This is not code you would put in an event on the continuous form unless you
put the option group in the form's header section.
On Jan 2, 3:21 pm, Wayne-I-M <
[email protected]>
wrote:
Hi
You could run one report showing just Ticks and another report showing
"not
ticks". Sorry don't know the right english for that but hope you
understand.
You don't need to make a new table.
You could use a form with a toggle box like this
Private Sub FrameName_AfterUpdate()
Select Case Me!FrameNameSelect
Case 1
DoCmd.OpenReport "ReportName", acViewPreview, "", "[FieldName]=-1",
acNormal
Case 2
DoCmd.OpenReport "ReportName", acViewPreview, "", "[FieldName]=0",
acNormal
End Select
End Sub
Of course change Report Name - Field Name - Frame Name.
There are lots of way to do what you want but creating a new table will
just
make more work.
--
Wayne
Manchester, England.
:
Yes, many of us know how to do this and most would recommend against
it.
We'll need a little more information regarding what you actuallyare
trying
to accomplish since leaving the data in the existing table allows you
to
control what is selected by using criteria. Are you asking to delete
from
table1 and append to table2 or leave the rows in table1 but makea
copy in
table2. Will you be recreating table2 each time or are you adding rows
to
an existing table? Both the adding and deleting processes will be done
with
queries. If your process is a "move", you will need to run the query
that
appends to table2 prior to running the query that deletes from table1.
There is no "move" action so the "move" must be handled by two
separate
queries.
Hi folks,
I have a field Yes/No and when the box is (checked) I want thedata
to
be transfer to another table
with the same value "Yes"
Dosen't anyone knows how can I do this?
Thanking you all in advance for your help!
Fred's- Hide quoted text -
- Show quoted text -
I want to copy the information from a delivery into another table when
the delivery is received (with a check box Yes/No), so I can make
reports. One for Deliveries received and another one report for the
Non-received deliveries.- Hide quoted text -
- Show quoted text -
Hi Wayne,
The check box is on a continuous form. How can i use your vba code?- Hide quoted text -
- Show quoted text -