Open a form with button, close, and resume focus on original record in main form

[HeadGasket]

THIS HAS BEEN SOLVED. SOMETHING MESSED UP AND CANNOT PUT SOLVED ON THE THREAD TITLE


My idea was this...When entering a new record into the main form and discovering that the Part Number I'm trying to enter isn't in the db yet (indexed), that by clicking on the Enter New Part Number button, type in new number, exit the Enter New Part Number form, and resume back to my main form at the same record I was originally on with the main form having been requeried so now the new Part Number will show up in my combo box.

Any suggestions?

Attachment 6025

[pbaldy]

I get an error trying to view the screen shots, but the most common way of doing this wouldn't be a button, it would be using the Not in List event of the combo. Seaching here on "notinlist" should turn up the two common methods.

[HeadGasket]

Thanks, pbaldy. The problem with the screen shots was probably due to me trying to remove, edit, and re-attach them. You may have looked at them while I was doing that. Fixed it. Now there is only one screen shot.

I will look into the "notinlist" method. Thanks, yet again.

[HeadGasket]

I checked out "NotInList" and don't see how to get it to do what I would like.

I've attached two more screen shots for reference of what I would hope to accomplish.

I'm attempting to be able to discover that a Part Number is not in the database yet, open up the form to create a new Part Number, close it, revert back to the main form (requeried) at the same record and then type in the new part number in the combo box.

I already have the button and related form working. Just need help requering the main form and pulling up the original record that was being worked on.

Suggestions?

Attachment 6028 Attachment 6029

[pbaldy]

Well, how it would work would be to replace your step 2. The user would type in the new part number into the combo, and if it didn't exist that event triggers a process to add it. The user wouldn't need to go click a button. If you want to use your button, you could adapt this:

http://www.baldyweb.com/Requery.htm

to go back to the record after the requery.

[pbaldy]

By the way, have you tried just requerying the combo rather than the whole form? If that's all that's needed, it should leave you on the same record.

[HeadGasket]

I tried just doing the requery on the combo box but still can't get it to work. Perhaps I don't understand the proper format.

Here is what I tried in the On Got Focus of the combo box:

Private Sub PNID_GotFocus()
Me.Requery
End Sub

......and tried this as well

Private Sub PNID_GotFocus()
Requery
End Sub

Both of them cause the view to go back to record #1. I'm stumped. Will keep digging through the forum and Google.

[pbaldy]

Try

Me.ComboName.Requery

[HeadGasket]

Thanks again, pbaldy! Works like a charm. Such a simple solution.

[pbaldy]

No problem! "Me" refers to the form, so whatever event you might use it in, it still refers to the form, not the control the event is for.

[HeadGasket]

Somehow I messed up the "Solved" step and can't seem to add it to the original post so everyone sees it has been solved. Oops.

[pbaldy]

Gotcha covered.