UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
> Requery Of Combox Box Issue, Access 2007    
 
   
Leah
post May 19 2017, 11:28 AM
Post#1



Posts: 615
Joined: 22-February 00
From: New York, New York


My combo box lists document names and returns the unique row that corresponds. If I change the name or add a new document row I want the list to update.

First I tried:

Private Sub Document_Name_AfterUpdate()

Me.cmbdocument.Requery

End Sub

That did not work.

Then I tried

Private Sub Document_Name_AfterUpdate()

Me.Requery

Me.cmbdocument.Requery

End

That worked however it goes back to tab 0. Document_Name is on tab one and I want it to go to tab two.

Then I figured that I really don't need to requery everything unless I need a different value in the combo box

I tried:

Private Sub cmbdocument_Click()

Me.Requery

Me.cmbdocument.Requery

End Sub

That does absolutely nothing.

I would be happy if I could get it to go to tab 2 when I click out instead of tab 1 which is the primary key which is an auto number. Actually I want it to remember the field I am on and go to the next one when I click out instead of going to tab 0 as there are other fields changes where I need to update the combo box.

Anyway I am probably not taking the best approach. Please advise.

Thanks

Leah
This post has been edited by Leah: May 19 2017, 11:37 AM

--------------------
Leah A. Kopel
Go to the top of the page
 

Posts in this topic



Custom Search
RSSSearch   Top   Lo-Fi    22nd May 2017 - 08:10 PM