Hi everyone,
I wonder if you are able to assist me at all?
I am using Access 2010 and am attempting to build an internal skills database for my organisation.
I am almost there, but am struggling with the final hurdle...
I have designed a form, which opens automatically when the database is opened. This is very similar to a well known search engine in relation to look and feel it has a single text box [SearchBox] and a command button to click on in order to search the database when this button is clicked.
Attached to the button is a macro, which opens a pre-designed report and actions the filter based on what was entered in the [SearchBox] field.
Below is the code that is run:
[Category] Like "*" & [Forms]![frmSkillsSearch]![SearchBox] & "*" Or [KeyWords] Like "*" & [Forms]![frmSkillsSearch]![SearchBox] & "*"
Within the report is a SubForm, which has the same functionality as the original form (the text box is called [SearchBox1]), but I cannot get the macro attached to the command button on the subform to re-filter the results?
I think it may have something to do with the original filter from the initial form...
Any suggestions?
Cheers
Ryan
I wonder if you are able to assist me at all?
I am using Access 2010 and am attempting to build an internal skills database for my organisation.
I am almost there, but am struggling with the final hurdle...
I have designed a form, which opens automatically when the database is opened. This is very similar to a well known search engine in relation to look and feel it has a single text box [SearchBox] and a command button to click on in order to search the database when this button is clicked.
Attached to the button is a macro, which opens a pre-designed report and actions the filter based on what was entered in the [SearchBox] field.
Below is the code that is run:
[Category] Like "*" & [Forms]![frmSkillsSearch]![SearchBox] & "*" Or [KeyWords] Like "*" & [Forms]![frmSkillsSearch]![SearchBox] & "*"
Within the report is a SubForm, which has the same functionality as the original form (the text box is called [SearchBox1]), but I cannot get the macro attached to the command button on the subform to re-filter the results?
I think it may have something to do with the original filter from the initial form...
Any suggestions?
Cheers
Ryan