Display only area on a form

[pvg]

How to put in a display only area on a form, Customer name & address when their code is entered on a form after the user leaves the custid field.&nbsp;&nbsp;The display only area shows the info if found and does not enter the box with the customer name&address but goes on to the next field. Order and Customer table is joined on custID.&nbsp;&nbsp;If not found a message pops out in red saying &quot;Customer NOT on File&quot; in the display only box.<br><br>Thanks

 

[DougP]

I would have two extra things on your form.<br>a Textbox where they key in the customer and a button to press to search the table.<br>The code in the button would search the table for the customer. If they exist then populate the appropriate boxes and Set focus to a box you choose.<br>Else if they don't exist display a msgbox &quot;Customer NOT on File&quot;<br><br>OK <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.