No Current Record error - Continuous Form

[tylerg11]

I have a main form which has a continuous form (subform) on it. Once field from the selected record in the continuous form sets the SQl statement for another subform. This code works great, except that sometimes I get a "no current record" error when the main form refreshes. Could be a bug with the continuous forms? Even though the arrow is on a record, it isn't really selected. Any way to select a record with VBA?

[Bob Fitz]

Just a thought in passing while you're waiting for someone who actually "knows" what the're talking about.
Could it be that you need to set the focus to that form and/or a control on it?

[June7]

I don't understand what you are describing. Why would the main form be influenced by setting SQL of another form?

Want to provide db for analysis? Follow instructions at bottom of my post.

[Missinglinq]

...Any way to select a record with VBA?

Like Bob and June7, I have no idea what you're trying to say, here! But as to the above question

DoCmd.RunCommand acCmdSelectRecord

Linq ;0)>