Hi,<br>
<br>
I have a form that has a table as it's Record Source. I need be able to select records (whose fields will fill a bunch of textboxes on the form) based on an 'order' number, which is unique. I am loading the combo box with the order numbers, and now I need to be able to populate all the controls on the form with the record that was selected in the combobox. Problem is, I can't figure out how to do it. I've tried using the AfterUpdate event of the combobox to execute the DoCmd.FindRecord method, but it doesn't seem to do what I want. <br>
<br>
I know that this should be an easy task, as I assumed it would be, but it has proven to be more daunting than I expected. The users don't want to search using the navigation buttons, because it is too limiting. Could someone please help me out here? I would really appreciate it.<br>
<br>
Thanks in advance!<br>
<br>
-Marc
<br>
I have a form that has a table as it's Record Source. I need be able to select records (whose fields will fill a bunch of textboxes on the form) based on an 'order' number, which is unique. I am loading the combo box with the order numbers, and now I need to be able to populate all the controls on the form with the record that was selected in the combobox. Problem is, I can't figure out how to do it. I've tried using the AfterUpdate event of the combobox to execute the DoCmd.FindRecord method, but it doesn't seem to do what I want. <br>
<br>
I know that this should be an easy task, as I assumed it would be, but it has proven to be more daunting than I expected. The users don't want to search using the navigation buttons, because it is too limiting. Could someone please help me out here? I would really appreciate it.<br>
<br>
Thanks in advance!<br>
<br>
-Marc
