Loosing list box slection after refresh

[oakoen]

I have a form (Main) with a list box (customer_name) and tabbed pages that show info from related tables about the customer selected.



One tab page has a button that pops up a different form, adds a new record with the data selected in the list_box. That works.

Here is where my issue lies.

When the pop up form is closed and the main form refreshed to show the newly added record, the tabbed pages that showed info for the selection in the list box defaults back to the first record even though the list box still shows the original selection highlighted.

I hope that makes sense.

I am not a guru. Got this far using google and by trial and error. If you can help please KISS.

Thank you in advance.

John

[pbaldy]

Is this the issue?

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

[oakoen]

Yes! Thank you, that is exactly the issue. Works like a charm.

Is there a way to accomplish this with out user interaction? Like on the close of another form???

[pbaldy]

Sure, you should be able to do the same thing from the close event of the other form. You would need to change the "Me" form references to the full form reference.

[oakoen]

Thank you very much!!!!!!!!

Exactly what I needed.

[pbaldy]

Happy to help!

[warmlf]

I am having the same issue but am not sure how to apply your code or where to apply it. I am very new to access so please be nice to me I have a form with a button that closes the form and opens another to add a record. When I am finished adding the record there is a button that closes that form and brings me back to the original form but this time with a filter for the current record. Now i want to click the combobox and go to a different record. I was able to clear the filter by putting in: Private Sub cboMovieTitle_Click()
Me.Filter = ""
Me.FilterOn = False
End Sub

That was all good so far.
Now the problem.
When I select a record it goes to the first record only. I have to reselect again to go to a different record. You guys sound like you probably have an easy sollution and maybe the requery you posted was it. Like oakoen I don't want any special user input. thanks in advance for your help.