Search results

I have attached the folder to this message now

My computer not recognizing me.filter

Not letin me save it as a zip

Dosen't work the filter still so not appear.

Yea but if i drop that bit of code then other clients information is visible in the background, while the user enters the search criteria.

Yea but if i just do the filter then other peoples information is visible in the back ground which is not suitable for confidentiality reasons.

Hi, Having a problem with this code again. It worked but the filter in the code has stopped working and I can't figure out why, can you help? thanks. DoCmd.OpenForm "tbljobs main" DoCmd.GoToRecord , , acNewRec DoCmd.ApplyFilter "jobs form search, , ,"

Thanks mate it working now

Hi, I am writing some code for a database button but the error message argument not optional appears, saying that my OpenForm is incorrect. The code is below can any body help? Thanks. Private Sub Command47_Click() DoCmd.OpenForm.[tbljobs main] DoCmd.GoToRecord , , acNewRec DoCmd.ApplyFilter...