>>>>I have a combobox who's dropdown list shows up as empty when it shouldn't.
>>>>In the DropDown() method I have something like this:
>>>>
>>>>lnQResult = REQUERY(viewname)
>>>>
>>>>IF lnQResult <> 1
>>>> Wait Window ('Requery problem')
>>>>ELSE
>>>> This.Requery()
>>>> wait window ('Made it this far')
>>>> This.Refresh()
>>>> If This.ListCount = 0
>>>> Wait Window ('empty list')
>>>> EndIF
>>>>EndIf
>>>>
>>>>I get the problem with this sequence of actions:
>>>>
>>>>1. Users clicks the down arrow - the view has a bunch of records, the user selects one.
>>>>2. User takes focus off the combobox, then goes back to the combobox and clicks the down arrow.
>>>>3. This time, there is only 1 record in the view, so that is what they select.
>>>>4. User takes focus off the combobox, then goes back to the combobox and clicks the down arrow.
>>>>5. This time the view has a bunch of records, but the list shows up empty! Plus the listcount is NOT equal to zero!!
>>>>6. If they click the down arrow a second time, it works.
>>>>
>>>>I can repeat this 100% of the time. Does ANYONE have ANY idea on a work around for this? I've tried it with VFP7 and 8...same problem.
>>>>
>>>>Thanks!
>>>
>>>Victor,
>>>
>>>I have seen this type of behaviour with the combobox, listbox and grid when it related to a cursor / table. The cause, I believe, is the record pointer the control believes it should be on, no longer exist and it appears blank. I have set the pointer to the first record, refreshed the control, requeried, then refreshed the control again to get this behaviour to stop.
>>>
>>>HTH,
>>
>>hmmmmm...well I tried that and still seem to have the same behavoir, I still have to hit the down arrow 2 times. Maybe I can put the code that's in the downarrow in a new method and just run it two times??
>>I've had problems like this in the past and actualy ended up putting a textbox on top of the combobox to get it to do what I wanted. It just seems insane to do something like that though.
>
>I'm sure I had to refresh the object more than once for the information to correctly appear. I was just having the problem yesterday with a grid, after deleting a record in it. I rebuilt the cursor, and the grid was blank. Added Go Top in Cursor, Grid.Refresh() cured the problem. I have seen the behaviour before in comboboxes, and cleaned it up the same way then. Wish I could have been more help.


Well I'm closer to getting it to work. Since the problem only happens when the prior dropdown resulted in just one record I did something like this:

lnQResult = REQUERY(viewname)

IF lnQResult <> 1
Wait Window ('Requery problem')
ELSE
IF RECCOUNT(viewname) = 1
This.Value = &viewname..field_key
This.Valid()
lcParameter = 'Something that will return zero results'
lnQResult = REQUERY(viewname)
EndIF
This.Requery()
wait window ('Made it this far')
This.Refresh()
EndIf


oooook. So now my problem is with the line that says "This.Value = &viewname..field_key". Now I get a "record out of range" error! Thinking that maybe it was the view, I put in
This.Value = 'Example'
and still got the same error - so the "record out of range" error is from the combobox! Anyone got any ideas/workarounds for THIS problem now? geeeeze what a pain in the neck!