Searching

[bgcogen]

Hi.
Does anyone know how to properly create a search record button??

I put one into a form of mine and when I click it I get the prompt to enter my 'Log number' but when I click OK it says it can't find that record, but I know its there. I want the details of the chosen record to be displayed in the form.

Thanks a million, any ideas??
Declan

 

[ColinEssex]

You can do it without needing a search button. In design view of the form use the combo box wizard. Select the third option (Find a record on a form based on the value I select in my combo box). Select the log number (or whatever) from the available list and follow the wizard through to the end. Then when you select a log number from the available list, it will bring the appropriate persons record up for view

Hope this helps
Col

 

[bgcogen]

Thanks

 

[113deluxe]

What vs of access are you running? I have access 2000 and I don`t have this third option in the combo box wizard. I`m working on the same problem as mentioned in this thread so this would help me out alot if I had this option.