RE: If msgbox is yes then checkbox is checked?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi Michael,

So if i have a form that pops up when the main form is closed that asks if
the information has been revised, which works, however how do i get the popup
form to open to correct record, i have tried variaitions of code i could find
for filtering but for some reason i cant get it to work,

"Michael Stanbarger" wrote:

I would suggest creating a small form for this instead of using a MsgBox
script. This way you can bind it to the table that has the field you want to
change.




--
Michael Stanbarger
Air Freight Coordinator
CRST Van Expedited


"Erin Freeman" wrote:


Hi there

For some reason i cant get this code to work. On the "On Close" action of a
form, i want a checkbox to pop up to ask whether the data has been changed,
if the user chooses yes then i want my "revised" checkbox to populate with a
checkmark

'If MsgBox(" Have you revised this data?", vbYesNo) = vbYes Then
'Me.chkrevised = True

'End If

It doesnt seem to work, not sure what i am doing wrong. any help would be
greatly appreciated.

Thanks


.

Relevant Pages

  • If msgbox is yes then checkbox is checked?
    ... For some reason i cant get this code to work. ... form, i want a checkbox to pop up to ask whether the data has been changed, ... It doesnt seem to work, not sure what i am doing wrong. ...
    (microsoft.public.access.formscoding)
  • Re: If msgbox is yes then checkbox is checked?
    ... The Before Update event runs only if the record has been revised. ... "Michael Stanbarger" wrote: ... > For some reason i cant get this code to work. ... > form, i want a checkbox to pop up to ask whether the data has been> changed, ...
    (microsoft.public.access.formscoding)
  • Re: Horses needing shoes?
    ... physiological reason why high performance cant be done barefoot..and ... head around being barefoot and jumping particularly seemed so weird ... Traction is a big reason at least for jumpers and eventers (I don't ... is cool, but I have jumped horses in Easy Boots and MHO, I ...
    (rec.equestrian)
  • Re: OT: Lets Take the Religion out of Christmas
    ... >> meaning if it requires arithmetic but cant use such arithmetic. ... and that is what non-provable means in this context. ... then there is no "reason" for the statement. ... > Your invocation of the incompleteness theorem is typical of many ...
    (sci.electronics.design)
  • Re: Contributing to u.r.c. Jelly babies in short supply
    ... | Any reason why you saw little worth? ... | It could be that the questions were of "little worth" but I have to ... Or perhaps your happy to reinforce the prejudices ... Indeed you made your own prejudices, saw what you expected to see, cant ...
    (uk.religion.christian)