Closing a form

[nevertool8]

I have a form (call it FORM A) with several fields on it bound to an underlying table (Call it Table A). One of the entry fields is a combo box, with its property set to Limit to List. When I type something into the combo box that is not in another table (call it Table B), it opens a new FORM (FORM B) which allows the user to enter the new piece of data which is then written to TABLE B. All of this, so far, works perfectly 100%. The problem is, after that entry is made on FORM B, I want it to return immediately and automatically to FORM A. Eventually it does, but I have to manually click on close two or three times (it re-displays FORM B) before it returns to FORM A. Once it does return to FORM A, the value that was entered on FORM B does in fact appear in the combo box, and all is well. But each time FORM B is called by the combo box on FORM A, I want it to be a one-time only entry before returning to FORM A. I've tried using an event code for Close Form and Close Window, but neither works. There must be some way, other than manually clicking a button, to have FORM B close automatically as soon as an entry is made, and then simply return to FORM A. Hope this makes sense. Thank you.

[Micron]

should not have to click more than once to close form2 and go back to 1st form. Suspect either code is running that prevents that, or you have turned off warnings at some point thus you are not responding to a problem because there is no message. Either
- look for code that turns off warnings and disable that and test again or
- post enough code so that we can follow through the sequence of events involved or
- post a zipped copy of your db. You may have to compact/repair it first, but you should always back up the db before doing so.

[nevertool8]

should not have to click more than once to close form2 and go back to 1st form. Suspect either code is running that prevents that, or you have turned off warnings at some point thus you are not responding to a problem because there is no message. Either
- look for code that turns off warnings and disable that and test again or
- post enough code so that we can follow through the sequence of events involved or
- post a zipped copy of your db. You may have to compact/repair it first, but you should always back up the db before doing so.

Thank you. Your post made me look at my code for the not-in-list event (the code that calls FORMB), and sure enough, I had inadvertently loaded the form twice. As soon as I removed the duplicated line in the code, everything worked perfectly. Thank you again.

[Micron]

glad you figured it out!
good luck with your db