Form asks for value on closing

[Rubi]

Hi all,

I have a form that has a bunch of controlers and a close form button.
when i press the button the form asks me the value of one of the textboxes on the form. how can that be?
what can i do to fix it ?

 

[Mile-O]

What happens when you close the form?

Are you opening another form? If so, what's that form's recordsource? Does this recordsource rely on a value found on the form you've just closed? How is it expected to get this value if you close the form?


Are you using code or a macro to perform this operation?

 

[Rubi]

after closing the form the program goes back to the "main menu" - a simple navigation form that doesn't or present any data.

i made the "exit button" with the access macro, so it's one VB command: close.form...

 

[Rubi]

correction: that's access wizard, not access macro.
this command is executed with VB code.

 

[coryt]

Rubi
What exactly is the message you are getting say??????
Is it say that "Your field cannot contain a null value" or is it displaying a messagebox you told it to display if the field is blank.