Good Afternoon. I am looking for some help with code to filter a form that I will be opening. I would like to click on a button to open a 2nd form and have it filtered as per a employee name. Each employee will have there own button with there name on it and there record will show once they click there button and the new form is opened. All there names are entered into the table for the record source under the column "Name". I know this shouldn't be to hard, but I am still a new user to Access. Here is the code I have so far. I know the combo part will need to be changed.
DoCmd.OpenForm "BAE Contact Info", , , "[Name] = """ & Me.Combo19.Column(1) & """"
DoCmd.Close acForm, "Employees"
Please use John Smith as a example employee name. Please feel free to ask any questions if I wasn't clear. Thanks for the help.
DoCmd.OpenForm "BAE Contact Info", , , "[Name] = """ & Me.Combo19.Column(1) & """"
DoCmd.Close acForm, "Employees"
Please use John Smith as a example employee name. Please feel free to ask any questions if I wasn't clear. Thanks for the help.