Search Form

[trident]

Re: https://www.accessforums.net/reports...der-40271.html



this is quite helpful. thank you June7.

However, when I use the sample that was given and made it myself, a dialog box appears and asked to type what to search which was already written in the combo box.

In the Query, I wrote the following:

Like [forms]![searchforms].[Folder] & "*"

when I created the SEARCH Button, this always appear even though it was already placed in the combo box.

can you help me please.

[June7]

Folder is the name of the combobox?

Want to provide your db for analysis?

[trident]

Folder is the name of the combobox?

Want to provide your db for analysis?

i am trying to attached the db but it is not pushing through, it is asking that the file should only be 500KB, the file is 2,044kb even though i deleted the data in the table

[June7]

Did you run Compact & Repair? Then zip the file - 2MB zip allowed. If still too big, can upload to fileshare site such as Box.com and post link to the file.