New autofill data

[Guest]

I have a combo box (on EntryForm form) that is working fine retrieving data
from a table (Materials). My problem is that when new data is entered, the
user cannot select the new word in the combo box unless that form has been
closed and reopened. The result is that the user has to enter a new value
more than once and when the Materials table is opened - that new value will
be in the table more than once. Any ideas? I've tried to requery the field in
the EntryForm AND in the Material form (when user adds new word to table).
That didn't work. Thanks!

 

[Alex White MCDBA MCSE]

Hi Kim,

have you tried the requery method of the combo box, e.g. me.cbotest.Requery,
it is a good idea to come up with a standard F key for refreshing combo
boxes I personallally use F5 set key preview on for the page, then use the
following event

Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)
if KeyCode = whatever_key then
Me.cboStage.Requery
end if
End Sub

 

[Guest]

The "me.cbotest.Requery" worked. Thanks!!

Hi Kim,

have you tried the requery method of the combo box, e.g. me.cbotest.Requery,
it is a good idea to come up with a standard F key for refreshing combo
boxes I personallally use F5 set key preview on for the page, then use the
following event

Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)
if KeyCode = whatever_key then
Me.cboStage.Requery
end if
End Sub

--
Regards

Alex White MCDBA MCSE
http://www.intralan.co.uk