Combo box not refreshing

[Lanason]

Dear All

I have a tabular form with a combo box lookup based upon a query that restricts the data based upon another field on the same line.

Problem is that the first time I open the form and look at a line it works, but if I move to another record above or below the Combo box seems to be based on the previous record:banghead:

How do I refresh so that the combo is always current ?

 

[pr2-eugin]

Okay, based on your description, I have the following premise.
* The Form is Continuous. (?)
* You have the ComboBox unbound (?)
* You have the code to refresh the ComboBox in Form_Current (?)

 

[Dmak]

On the forms VBA you'll need to trigger a requery for the control of the whole form.

Something along the lines of;

Me.Combobox.Requery

Add this to the AfterUpdate event of whatever it is you're using to change the record.

 

[Lanason]

Okay, based on your description, I have the following premise.
* The Form is Continuous. (?) I guess so but dont know
* You have the ComboBox unbound (?) no its bound to a field
* You have the code to refresh the ComboBox in Form_Current no code to refresh - how do I do it (?)

see above for my anwsers

 

[Lanason]

On the forms VBA you'll need to trigger a requery for the control of the whole form.

Something along the lines of;

Me.Combobox.Requery

Add this to the AfterUpdate event of whatever it is you're using to change the record.

do you mean I put this on the form control ? on which property.

i am moving between records on the screen and the combo box list is the same as the first record I looked at. If I close the form and reopen it resets the combo box for use first time. Not sure I am explaining myself too well

 

[Dmak]

Can you upload a screenshot of the form?