Find (and go to) a record..

[torie_h]

Hi All,

I'm wondering if anybody can help me? My knowledge of code has deteriorated slightly (completely) and I'm trying to set up a search box within a form. I've gotten as far as a combo box which is terrific as I can either type or select a name from the drop box....... but I can't get it to setfocus on that record.

I don't just want to go to a seperate (ctrl+f) box every time I want to find a name - is there any way I can go from my combo box?

Another issue that I'm having is setting up a login page. It's a staff database that is only to be accessed by managers to get employee's contact details so I need to know that only managers have access to it. I've set up a table with log ins and passwords and a form with another combo box for names and text box (input masked for passwords) and tried my hand at the code... It doesn't work. Does anybody know the code needed to grant access if the password is found to match the log in name and bring up an error message if not? Because I expect that mine needs to go in the bin.

Thanks!!!

 

[missinglinq]

For the first question, your form has to be bound to the Recordset (Table or Query) that holds the records you're trying to retrieve. Assuming that this is so, delete your combobox and create a new one. This time choose the third option,
"Find a record on my form based on the value I selected in my combobox"

Making a selection from the combobox should then retrieve the record.

As to the second question, this link has an attached database that addresses the problem

http://www.dbforums.com/6222312-post5.html

Linq ;0)>