me.filter small problem

T

Ticotion

Hi

I have a form containing a combo box that contains department names and a
text box containing a value that is linked to the department via a department
table.

When the user choose a department from the combinations box the according
value should appear in the text box.

I use the following statement but get an notation error.

Private Sub combinationsboks16_BeforeUpdate()

Me.Filter = "[dpt] = " & Me.combinationsboks16

Me.FilterOn = True

End Sub

please help

Ticotion
 
G

Golfinray

Use Me.Filter = "[dpt] = """ & Me.combonationasbox16 & """"
Me.filteron = true
And use the afterupdate event.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

filter on dates 2
Filter difficulties 8
Filtering and Removing Filter based on a combo box 4
Runtime error 2001 2
Filtered field goes blank 2
multiple cascading combo boxes 1
To hinghlitht the searched words 3
Combo Box to select a record and populate fields in a form 2

Top