Change focus on form

[christinamasalha]

Hello again,

Im hoping somebody can help me with this problem :)

In my database i have a from called "Farms", on the from i have 1 fields called "Farm_Name" and a subform called "Houses". When the focus leaves the last field in the Houses subform i want the cursor to return to the main form and for the last record entered in the subform to still show.....to do this i used the following code on the "OnLostFocus" event of the last field in the subform.

 
 Forms![Farms]![Farm_Name].SetFocus
      Forms![Farms]![Houses].Requery
 

Till now everything is still working great....The problem is that when i try to return to the subform "Houses" the cursor wont leave the main forms "Farm_Name" field.

I dont know whats going on. Any help would be greatly appreciated.
Thanks alot,
Christina

[missinglinq]

I'm not sure of the why but it sounds like you're looping right back to the piece of code thhat you posted so that you're forever setting focus back on the control in the main form.

[christinamasalha]

I'm not sure of the why but it sounds like you're looping right back to the piece of code thhat you posted so that you're forever setting focus back on the control in the main form.

thanks for the reply,

if i remove the requery methode it works, but the problem is that the fields in the subform are then cleared, and i need them to show.
So im thinking the problem is in the Requery.