.Undo for unbound controls?

[ARC]

I've noticed that if you use code for the before update command for unbound
controls, it doesn't really work.

I tried the following:

Me!ExportedYN.u ndo
Cancel = True
DoCmd.CancelEve nt
Exit Sub

However, putting the above code in the before update on unbound controls
does NOT undo their typing. Does anyone know the proper way for unbound
controls?

Many Thanks,

[Bob Quintal]

"ARC" <an**@andyc.com wrote in
news:BY******** ***********@new ssvr25.news.pro digy.net:

I've noticed that if you use code for the before update
command for unbound controls, it doesn't really work.

I tried the following:

Me!ExportedYN.u ndo
Cancel = True
DoCmd.CancelEve nt
Exit Sub

However, putting the above code in the before update on
unbound controls does NOT undo their typing. Does anyone know
the proper way for unbound controls?

Many Thanks,

The reason is that the before update event may reject an entry
because of a spelling misteak and users get annoyed if they have
to retype the whole mistake instead of just editing the
previously typed data.

In addition to the Cancel = true statement,
put me.ExportedYN.t ext = ""
(I'm guessing that ExportedYN is your control name. .

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

[ARC]

Yes, the ExportedYN is the control name, and it is a checkbox. I tried
setting it back to ExportedYN = 0, but it didn't work...
"Bob Quintal" <rq******@sPAmp atico.cawrote in message
news:Xn******** **************@ 66.150.105.47.. .

"ARC" <an**@andyc.com wrote in
news:BY******** ***********@new ssvr25.news.pro digy.net:

>I've noticed that if you use code for the before update
command for unbound controls, it doesn't really work.

I tried the following:

Me!ExportedYN. undo
Cancel = True
DoCmd.CancelEv ent
Exit Sub

However, putting the above code in the before update on
unbound controls does NOT undo their typing. Does anyone know
the proper way for unbound controls?

Many Thanks,

The reason is that the before update event may reject an entry
because of a spelling misteak and users get annoyed if they have
to retype the whole mistake instead of just editing the
previously typed data.

In addition to the Cancel = true statement,
put me.ExportedYN.t ext = ""
(I'm guessing that ExportedYN is your control name. .

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

[Bob Quintal]

"ARC" <an**@andyc.com wrote in
news:3G******** ***********@new ssvr21.news.pro digy.net:

Yes, the ExportedYN is the control name, and it is a checkbox.
I tried setting it back to ExportedYN = 0, but it didn't
work...

Ok, I misinterpreted your statement about " before update on
unbound controls does NOT undo their typing." since you don't
type anything into a checkbox.

Maybe if I understood more about what triggers the need to undo
the checkbox I might be able to offer better suggestions.

>
"Bob Quintal" <rq******@sPAmp atico.cawrote in message
news:Xn******** **************@ 66.150.105.47.. .

>"ARC" <an**@andyc.com wrote in
news:BY******* ************@ne wssvr25.news.pr odigy.net:

>>I've noticed that if you use code for the before update
command for unbound controls, it doesn't really work.

I tried the following:

Me!ExportedYN .undo
Cancel = True
DoCmd.CancelE vent
Exit Sub

However, putting the above code in the before update on
unbound controls does NOT undo their typing. Does anyone
know the proper way for unbound controls?

Many Thanks,

The reason is that the before update event may reject an
entry because of a spelling misteak and users get annoyed if
they have to retype the whole mistake instead of just editing
the previously typed data.

In addition to the Cancel = true statement,
put me.ExportedYN.t ext = ""
(I'm guessing that ExportedYN is your control name. .

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

[Marshall Barton]

ARC wrote:

>I've noticed that if you use code for the before update command for unbound
controls, it doesn't really work.

I tried the following:

Me!ExportedYN. undo
Cancel = True
DoCmd.CancelEv ent
Exit Sub

However, putting the above code in the before update on unbound controls
does NOT undo their typing. Does anyone know the proper way for unbound
controls?

Unbound controls do not have a "previous" value (that is in
the original current record), so Undo is meaningless (in the
context of its definition).

Can't you use the AfterUpdate event and just set the value
to a known value?

Note that in your code above, Cancel = True and CancelEvent
are equivalent and using both is redundant. Cancel = True
is the recommended approach.

--
Marsh

[ARC]

Thanks to both of you!

The need to undo the checkbox is because I have the detail showing repeating
lines, so the repeating lines are bound controls. The form header controls
are all unbound, and I'm saving them via code (since I can't have 2 records
sources, I have to do unbound in for the header controls). The checkbox is a
Taxexempt switch that saves with the header area.

If you want more detail:

Header controls are for a table called Invoices which contain the main
options for the invoice, like date, invoice number, tax exempt (checkbox),
etc. I have them all unbound, and am saving the data manually via code.

Detail controls are bound and use the table InvoiceDetail.

Wish there was a way to do a different record source for the header and
details, but you can't.

Hope that makes more sense,

"Bob Quintal" <rq******@sPAmp atico.cawrote in message
news:Xn******** **************@ 66.150.105.47.. .

"ARC" <an**@andyc.com wrote in
news:3G******** ***********@new ssvr21.news.pro digy.net:

>Yes, the ExportedYN is the control name, and it is a checkbox.
I tried setting it back to ExportedYN = 0, but it didn't
work...

Ok, I misinterpreted your statement about " before update on
unbound controls does NOT undo their typing." since you don't
type anything into a checkbox.

Maybe if I understood more about what triggers the need to undo
the checkbox I might be able to offer better suggestions.

>>
"Bob Quintal" <rq******@sPAmp atico.cawrote in message
news:Xn******* *************** @66.150.105.47. ..

>>"ARC" <an**@andyc.com wrote in
news:BY****** *************@n ewssvr25.news.p rodigy.net:

I've noticed that if you use code for the before update
command for unbound controls, it doesn't really work.

I tried the following:

Me!ExportedY N.undo
Cancel = True
DoCmd.Cancel Event
Exit Sub

However, putting the above code in the before update on
unbound controls does NOT undo their typing. Does anyone
know the proper way for unbound controls?

Many Thanks,

The reason is that the before update event may reject an
entry because of a spelling misteak and users get annoyed if
they have to retype the whole mistake instead of just editing
the previously typed data.

In addition to the Cancel = true statement,
put me.ExportedYN.t ext = ""
(I'm guessing that ExportedYN is your control name. .

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

[Marshall Barton]

ARC wrote:

>The need to undo the checkbox is because I have the detail showing repeating
lines, so the repeating lines are bound controls. The form header controls
are all unbound, and I'm saving them via code (since I can't have 2 records
sources, I have to do unbound in for the header controls). The checkbox is a
Taxexempt switch that saves with the header area.

If you want more detail:

Header controls are for a table called Invoices which contain the main
options for the invoice, like date, invoice number, tax exempt (checkbox),
etc. I have them all unbound, and am saving the data manually via code.

Detail controls are bound and use the table InvoiceDetail.

Wish there was a way to do a different record source for the header and
details, but you can't.

Seems like you a taking the road up and down the mountain
instead of just walking around the rocks ;-)

Is there a good reason why you are not using a subform for
the invoice details? This way the main form can be bound to
the Invoice record.

--
Marsh

[ARC]

Yes, because I'm trying the new Access 2007 split form. This way, I can use
one form and have the header area look nice and presentable, and still
utilize a datasheet type view in the detail. So if the user maximizes the
form, and is using a big resolution, the datasheet will fill the screen,
which my user's want. I've found if you use a subform, it won't auto-expand,
unless you code it on the resize event.
"Marshall Barton" <ma*********@wo wway.comwrote in message
news:cv******** *************** *********@4ax.c om...

ARC wrote:

>>The need to undo the checkbox is because I have the detail showing
repeating
lines, so the repeating lines are bound controls. The form header controls
are all unbound, and I'm saving them via code (since I can't have 2
records
sources, I have to do unbound in for the header controls). The checkbox is
a
Taxexempt switch that saves with the header area.

If you want more detail:

Header controls are for a table called Invoices which contain the main
options for the invoice, like date, invoice number, tax exempt (checkbox),
etc. I have them all unbound, and am saving the data manually via code.

Detail controls are bound and use the table InvoiceDetail.

Wish there was a way to do a different record source for the header and
details, but you can't.

Seems like you a taking the road up and down the mountain
instead of just walking around the rocks ;-)

Is there a good reason why you are not using a subform for
the invoice details? This way the main form can be bound to
the Invoice record.

--
Marsh