Combo Box Search Form function

[TheGeneral]

Hi All!

I am trying to add a search function to my database. there are a lot of post regarding this but there are seemingly so many ways to do this and i havent been able to resolve my issue from any of those posts so far.

basically i have added a combo box [TxtSearch] to the main page of my DB [FrmDashboard] this contains a drop down with my candidate names in and their relevant candidate ID's. Basically i want the users to find the name they are searchin for in the drop down selection and when they click the button next to it they will be taken to the relevant record in the form.

I have used macro builder to create the actions required from the button added and the code seems to work but wont take the value from the combo box. details below.

Combo box [TxtSearch] mounted to [FrmDashboard]

Macro Event Properties assigned to button -
Close
OpenForm - Where Condition - [Forms]![FrmDashboard]![TxtSearch]=[CandidateName]

This is to open [FrmWorkbook] to the relevant candidates record based on [CandidateName]

when a selection is made in the combo box and the button is pressed a modal "enter Parameter Value - Forms!FrmDashboard!TxtSearch" appears. when i type in the value in that box it does work.

i have tried changing my where clause to the following;

[Forms]![FrmDashboard]![TxtSearch]=[Forms]![FrmWorkbook]![CandidateName]

but to no avail. Would be extremely greatful if anyone has any suggestions or soloutions to my problem. I appreciate that this is probably a rookie mistake that has been made with probably only a small amendment needed but greatful all the same!

Thanks in anticipation!

 

[shutzy]

a guy called big john helped me out with a thread he created. it is a dynamic search that uses a query and a list box. click or dblclick a record in the list box and open another form to view the record in as much details as you require. or you could use a sub form below your list box instead of opening another form.

the link is
http://www.access-programmers.co.uk/forums/showthread.php?t=188663

this is fantastic and i have used this on many forms.