Require Data Entry on Pop Up Form

[Guest]

Hello,

I have a main form that has a button to bring up a pop up form. I want a
warning to be triggered based on a particular field's value that would
require the user to enter data into the pop up form if that field's value
meets certain criteria.

I have put code in the form's On Current event that does bring up this
message box, but my dilema is that it triggers all the time the field's value
is that certain criteria, even after I have entered data into the pop up
form. What I want is for the event not to trigger if the pop up form has
been filled in. I'm sure it's a couple of lines of code that tests if the
pop up form has been filled in, but I'm at a loss.

Thanks for your help.
DMC

 

[DW]

THIS IS AN ASSUMPTION!
Im not sure about this due to the lack of information(NO OFFENSE) but if you
were wanting to open a form based on a specific value entered in a textbox,
instead of putting your code in the forms OnCurrent Event, why not put it in
the textbox's AfterUpdate event.
If you use the OnCurrent Event to monitor a textbox, every time the form
goes to a different record, it will see that the text matches the criteria,
where as if you wait until the user enters the data your code should execute
after the data is entered. Depending on timing needed for your data, If you
need specific data entered before the data is put into the textbox, you
might want to trigger your code before it updates.
If this doesnt help, you might try replying again to this post with your
code, and specify where/what/how your forms are.

DW

 

[Guest]

DW,

That sounds plausible, but what if the user has already filled in data into
the pop up form. I don't want it to pop up for them again. I only want it
to pop up once.

Thanks,
DMC