Rich, it sounds like you are using the
screen values of your data to fill the cboSupplier instead of the
table values. Instead of putting the update in the combo GotFocus method, put it in the grid AfterRowColChange method, with a loop to make sure you have changed row, not just column. Then get the correct information from the new row value (cursor, table, view....) and update your combo.
HTH
Barbara
>Problem:
>I need to accurately determine the contents this row in a grid. I have columns for report name, state, county and supplier. If I change rows I need the information for Report name, State and County to be updated before executing the cboSupplier GotFocus method. I don't know why but as I change rows the information is not updated ...it shows the info for the row I just left....
>thisform.pageframe1.pagsearches.grdorderitems.colreportname.cboreportname.displayvalue
>thisform.pageframe1.pagsearches.grdorderitems.colreportname.cboreportname.value
>thisform.pageframe1.pagsearches.grdorderitems.colstate.cbo_state1.displayvalue
>thisform.pageframe1.pagsearches.grdorderitems.colstate.cbo_state1.value
>thisform.pageframe1.pagsearches.grdorderitems.colcounty.txtcounty.value
>The cboSupplier GotFocus method can not accurately run like this.
>
>If I click on or tab thru these fields the information is updated to what I need, but telling the user they have to do that is not right.
>
>
>If you can help it would be GREATLY APPRECIATED!!!!
>I'm stumped and coming up on deadline....