Switch between sub and main forms

[keri]

Hi again,

After puzzling all day I have (sort of) figured a round about way to
solve my problems.

I have a form callsmade with a subform allaccounts

On clicking on a record in the subform I wanted a field to be copied to
a bound textbox on my main form so I use this code;

Private Sub Form_Click()
[Forms]![CALLSMADE].Form!ACCOUNTID =
[Forms]![CALLSMADE]![ALLACCOUNTS].Form!ACCOUNTID
End Sub

This copies the information fine. However I then want the user to
select a value from a combo box on my main form and update a field in
my subform with this information so I use this;

Private Sub Combo60_AfterUpdate()
Form.Refresh
[Forms]![CALLSMADE]![ALLACCOUNTS].Form!CALLAGEFREQUENCY = Me.Combo60
[Forms]![CALLSMADE]![ALLACCOUNTS].Form.Refresh
End Sub

The problem I have is that after the first pice of code (sub
form_click) the focus seems to be on the subform and it won't let me
select my combobox in my main form.
In Excel (sorry I know it's totally different) I would code like below

eg
[Forms]![CALLSMADE].Form.activate

to refocus on the main form (and I hope doing this would solve my
problem of not being able to select my combo on the main form).

Does it seem like I have identified the problem correctly, and if so
how can I code to re-focus on my main form?

[keri]

Apologies for the duplicate.

I have discovered that I can't select anything from my combo box (after
the first onclick code has worked) until a lot of doublt clicking
highlights it. If I make a selection in the combo it only updates the
table if the selected record has a little pencil icon thing in the
margin next to it.

I presume this is some sort of edit mode - can I put this in my code?
On 26 Jan, 17:51, "keri" <[e-mail]:

Hi again,

After puzzling all day I have (sort of) figured a round about way to
solve my problems.

I have a form callsmade with a subform allaccounts

On clicking on a record in the subform I wanted a field to be copied to
a bound textbox on my main form so I use this code;

Private Sub Form_Click()
[Forms]![CALLSMADE].Form!ACCOUNTID =
[Forms]![CALLSMADE]![ALLACCOUNTS].Form!ACCOUNTID
End Sub

This copies the information fine. However I then want the user to
select a value from a combo box on my main form and update a field in
my subform with this information so I use this;

Private Sub Combo60_AfterUpdate()
Form.Refresh
[Forms]![CALLSMADE]![ALLACCOUNTS].Form!CALLAGEFREQUENCY = Me.Combo60
[Forms]![CALLSMADE]![ALLACCOUNTS].Form.Refresh
End Sub

The problem I have is that after the first pice of code (sub
form_click) the focus seems to be on the subform and it won't let me
select my combobox in my main form.
In Excel (sorry I know it's totally different) I would code like below

eg
[Forms]![CALLSMADE].Form.activate

to refocus on the main form (and I hope doing this would solve my
problem of not being able to select my combo on the main form).

Does it seem like I have identified the problem correctly, and if so
how can I code to re-focus on my main form?