Hello expert
i created one form in which i have four edit box ie Room No,Bed No,Ward type and Status.in Room no edit box i have CFL which choose all information like room no,bed no,ward type and status from database from this status edit box have default text Vaccant from database.i create one button on form that is Allot.Now i want when i click allot button the text of status edit box change to Occupied so pls tell update command for its