Search results

Never mind .... figured it out..... my record source and control source were all over the place... got it straightened out now.

Thanks for your help -- what I ended up doing was setting the fields as Visible=False and then added a before update event (on the combo box) to make the fields visible as soon as I picked a selection from the combo box.

I have a form with an embedded subform. Form has combo box -- when I select employee's name it gives me various pieces of information about the employee in the subform. I have an "Edit This" button in the subform and it sets up a filter to pull up the proper record (in form form) to edit...

My main form consists of an unbound combo box which lists all employees in alphabetical order, along with their id nbr. When I set up the combo box I chose the "find the records based on my table" option. The subform is a continuous form of work performance violations .... the user can...