Lookup and display 1

[storyboy]

On my data entry form, have entry of customer code, once this is filled in I want to display customer name and address from the file. I use dlookup and that works great for viewing data after the fact. I have the fields set to no entry and lock yes so the data will not dim, easier to see. I want the data displayed right away after the CCO(customer code) is entered and the focus is on to the next entry field. Don't want to enter or change customer name and address so focus on these fields isn't wanted. Please help me with this. I have same type of problem with product informations screen as the product ID is entered. Thank you in advance, seems there must be an easy way for this to take place.

 

[randy700]

How about using a combo box for your customer code entry. Use the wizard to created the combo box and select option 3 -- find a record based on my selection.


Randy

 

[storyboy]

RANDY700,
Thank you so much. Sometimes the simplest is the most overlooked. My eggs must be scrambled but thanks to support like yours, friendly, the result is at least an omelet.