Opdatere query for listbox via felt paa form

på afterUpdate eventen på textfeltet skriver du:

me.NavnListbox.requery

Hvis det skal være ved hvert tastetryk at du vil opdatere, så brug:

private sub NavnTextfelt_change()
me.NavnListbox.requery
end sub

Okay, synes jeg har proevet begge... Giver den lige en chance med change() igen. Kan ikke teste foer i morgen. Giver dig besked!

Very likely because the record you are editing has not yet been written to the database, so the listbox wont find the new record.

If you have a record selector on th eform you will very likely see that it is still in edit mode, so you need to save the record first.

You could put the code in fields lost focus event.

DoCmd.RunCommand acCmdSaveRecord
me.NavnListbox.requery

Terry, no record selector on the form. Not adding anything new, just need to filter a listbox containing about 300 entries to make it easier to identify the right ones.

spg, det virker ikke helt som forventet med change() - nu skal jeg klikke i listboxen for at den bliver opdateret efter text feltet er aendret?!?!

I think I know what the problem is, will get back ASAP, bit busy right now.

have you tried requery in the key up event?

Hmm, no, I haven't tried that one. Will do tomorrow. On Oz time, so taking a while to get back to you with the results :-)

I've tried it in the Key Up evet and it works OK.

Dont know how your using the criteia but if its lik ethis then it should work OK:

Like [Forms]![frmMyList]![MyFilter].[text] & "*"

.

Hi Terry,
Is that an event on the list or on the text field? Sorry if that's way to stupid to ask ;-)

Terry, I can't get the effin' thing to work!
I have a query that forms basis for the list, and it's criteria is
Like [forms]![main].[txtsitesearch] & "*"
In the code for the form I have:

Private Sub txtSiteSearch_KeyUp(KeyCode As Integer, Shift As Integer)
  Me![SiteList].Requery
End Sub

So when I update that text field, I want the listbox updated. But now I have to press enter before it's done...

does that make sense, or am I going about this in the wrong way?

Nu ved jeg godt hvad du laver, men jeg har ikke lige løst problemet, som er at der ikke står noget i feltet før afterupdate.... man kunne måske strikke noget sammen med keydown eventen, den indeholder en keycode, som kan laves om til et bogstav med chr(keycode) men det bliver nok stadig noget rod. En måde er at flytte focus frem og så tilbage, men så bliver det man har skrevet markeret hele tiden, så måske skulle du bare lave en dropdown liste i stedet for og så sige ja til autoudfyldelse!~)

spg, jeg har default vaerdi "" i feltet, saa der staar ikke noget. Ville det hjaelpe at aendre default vaerdi til "*" i forhold til din loesning?

Is it possible fro you to send me your dB or an example which is very similar?
ekspertenATsanthell.dk
AT = @

While you are entering data into the field th edata is in an 'edit' buffer so thats why you need to refere to the fields .text property which it seems you are doing.

So as far as I can se it should work in the Key UP (after the value is entered)

There should be no need to move focus anywhere, it should work as it is.

Mail sent. Thanks Terry!

Terry, thanks for that. With the keyup event and the other fixes to my way of doing it, it worked.
Like [Forms]![frmMyList]![MyFilter].[text] & "*" - Was missing the [text]

/Henrik