OpenForm Where problem

[MikeCampy]

I have a subform that has a memo field that holds comments. The key for this
memo field is a ReplicationID. Since this is a subform, there isn't much
room to view all of the comments in the memo field, so I created another pop-
up form to show an expanded view of the current record's memo field. The
problem I am having is that my Where statement is trying to synch the new
form to the original on that Replication key and it won't work. Can anyone
help guide me around this problem?

 

[Barry Gilbert]

Instead of opening another form, why not use the zoom box? In the GotFocus
event of the textbox, put this:
DoCmd.RunCommand acCmdZoomBox

HTH,
Barry

 

[MikeCampy]

That works great Barry.....thanks for your input!!

Instead of opening another form, why not use the zoom box? In the GotFocus
event of the textbox, put this:
DoCmd.RunCommand acCmdZoomBox

HTH,
Barry

I have a subform that has a memo field that holds comments. The key for this
memo field is a ReplicationID. Since this is a subform, there isn't much

[quoted text clipped - 3 lines]

form to the original on that Replication key and it won't work. Can anyone
help guide me around this problem?