To make it easier on the user in making a selection from a combo box, I am displaying a list of employee.nmbr, fname, lame in a dropdown combo box. The employee table is a parent and is ORDERed by nmbr. A child table's fields are displayed in a grid below for the selected employee.
Everything goes fine as long as the user either selects an employee from the dropdown combo or types in a valid employee.nmbr in the combo's edit area. However, if the user types in an invalid employee.nmbr in the combo edit area, the display still shows an employee.fname & lname in a label that I have placed just above the grid, to wit:
ThisForm.Label5.Caption= ;
ALLTRIM(prlink.fname)+" "+ ;
ALLTRIM(prlink.lname)
EXAMPLE:
If '9999' is entered into the combo's edit area, the employee's name from the last indexed record, '9801', is displayed.
Thanks in advance for the help, CH.
Chuck Henry