Filter Form

[MdHaziq]

Hello,

Forum

I am asked to filter my form to narrow down the search to make it easier to find the search item.

I am thinking of having a cbo dropdown box to filter by Subsystem and location. I was also wondering if it is possible to add a search box in the form?

I have afew more questions..

How do I use Case is to filter users in frmLogin that login to different forms. For my case directing them to different database. Currently I only have ECD Inv/Store. The rest of the forms I have not created.

Is it possible for me to filter reason based on chkbox in frmLog? As Stock in and Recon is for stock in. The rest are for withdrawing.



RptLog I use the Yes/No field to group my data.
I would like to use name such as Stockin and Withdraw instead of separating them based on checkbox.

Please help.

Thanks

Haziq

[ranman256]

you can filter on anything...
textbox:

sub txtBox_Afterupdate()
if IsNull(txtBox) then
   me.filterOn = false
else
   me.filter = "[field] like *" & me.txtBox & "*"
   me.filterOn = true
endif
end sub

cboBox:

sub cboBox_Afterupdate()
if IsNull(cboBox) then
   me.filterOn = false
else
   me.filter = "[field] ='" & me.cboBox& "'"
   me.filterOn = true
endif
end sub

[MdHaziq]

hello runman256,

I tried your code for cboBox. It works perfectly.

I tried to search using txtbox but I am having error 3075.

Is it possible for me to do cascading cbobox for search results as the filter I have is only for one field.

Thanks and Merry Christmas

Haziq