Capture Data

[David]

Is there a way to capture what a user puts in a textbox if a condition is
meet in vb code and not add it to a record

If you had a textbox that had code attached looking to see if there is
existing data on a table (got this to work and prompt a message box error
for them), how do you keep what they entered from being put onto the table?

if there is data that exist(on the table), being that this is a starting
point for them, I need to stop them from changing the starting point if data
does exist

 

[r0adh0g]

Use the before update event to check the contents of the text box.
If it is not what you want, pop up a msgbox and tell the user.....

rh