PopUp Form

[kybb1]

OK...so I'm a lame duck....

I have frmComments which has mmoComments. In the AfterUpdate event I have:

DoCmd.OpenForm "frmComType", acNormal, "", "", , acNormal

Then..................
the user makes a selection from cboComType which is in frmComType.

Then in the AfterUpdate event...................

Private Sub cboComType_AfterUpdate()
Forms!frmsComments!CommentType = Me.cboComType.Column(1)

DoCmd.Close

If IsLoaded("frmsComments") Then Forms!frmsComments.Visible = True

End Sub

But .....

table "tblComType" which is the recordsource for cboComType is updated and CommentType IS NOT.....

what on earth am I doing wrong? I set frmComType to POP UP.

Thanks in advance for any suggestions.

 

[WayneRyan]

Boo,

I see that you set the form's visible property, have you tried
doing a .Refresh.

Wayne

 

[kybb1]

Wayne,

Thanks for your help....as I was typing a response to you...LOL..it occurred to me what the problem was.

The recordsource for frmComments was a qry. The qry included tblComType which is what the text box CommentType was bound to.....therefore causing the problem....

Sorry to have cause any inconvienence.

BTW...what would .refresh have done short of requery?

Thanks.