Update

[Barcode]

Hello

I have this code that filtered from query to view the word list I write on a
field on a form,
so with every key I press on the field the word list it be closer.
This code it work on Access 2000 and not work on Access 2007.
Any help please to make it work on MS Access 2007 ?
Thanks a lot.


Private Sub Search_Change()

If Me.Option = 1 Then
Me.serv.Form.RecordSource = "SearchSv" ' Query

ElseIf Me.Option = 2 Then
Me.serv.Form.RecordSource = "SearchArb" ' Query

ElseIf Me.Option = 3 Then
Me.serv.Form.RecordSource = "SearchSv2" ' Query

ElseIf Me.Option = 4 Then
Me.serv.Form.RecordSource = "SearchArb2" ' Query

End If

Me.Requery
DoCmd.Requery "serv"
Dim dbs As Database, rs As Recordset
Set dbs = CurrentDb
Set rs = Me.serv.Form.Recordset

SendKeys "{F2 2}"
Me.Requery

End Sub

 

[Maurice]

would it help if you explicitly reference DAO?

so
dim dbs as DAO.Database
dim rs as DAO.Recordset

note: sendkeys? = not done...

 

[Barcode]

Hello

Thanks for replay.

I tested it, but there is not any effect ?

Me.Refresh

It work, but the problem is that the field I am writing on it be mark text
on it and I can not write more than only 1 charackter and when I press next
key, so it write over the charackter I already wrote before.