By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,827 Members | 2,277 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,827 IT Pros & Developers. It's quick & easy.

no loop

P: n/a
Set rs = Me.frm_sub.Form.Recordset
While Not rs.EOF
Me.frm_sub.Form.fldX = Me.frm_sub.Form.fldY * 0.1
rs.MoveNext
Wend

the upper source code is looping.
i want to get the result, without loop.
is it possible?

*** Sent via Developersdex http://www.developersdex.com ***
Nov 22 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a

x taol wrote:
Set rs = Me.frm_sub.Form.Recordset
While Not rs.EOF
Me.frm_sub.Form.fldX = Me.frm_sub.Form.fldY * 0.1
rs.MoveNext
Wend

the upper source code is looping.
i want to get the result, without loop.
is it possible?

*** Sent via Developersdex http://www.developersdex.com ***
Hi,
Maybe you just need to look at the query that you are using for
your recordset, and you could use an IF statement just to make sure
that you recordset has returned something.

Hope this helps

Nov 22 '06 #2

P: n/a
Just set the ControlSource property for the TextBox control containing
the value for the desired calculated field, fldY, to

=[fldX]*0.1

Nov 22 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.