Program flow with sub 1

[JDRoss]

I'm trying to have program flow pass to another procedure depending on an if statement result. However, the flow does not go to the other sub, wondering if anybody can help.

Regards

john

the code is as follows:

f rs.RecordCount > 0 Then
rs.FindFirst "Parishonersid = " & meparishonersid & " AND monthid = " & memonth & " AND yearid = " & meyear
'Record does not already exist if you reach the end of the file
If rs.EOF = True Then Monthly_Contribution_Amount_AfterUpdate

 

[KenReay]

Hi

To begin with

If you are trying to detect not found, the use Rs.NoMatch

Regards Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK
kenneth.reaySPAMNOT@talk21.com
remove SPAMNOT to use

 

[MichaelRed]

Actually, NoMatch is useful w/ DAO, while .EOF is the approach for ADO, so the choice is not so clear cut. Since the snippet of code is SO brief, it is not clear which construct should be used (other than the already-in-use .EOF). The other possability hinted at here is recordcount, but there is certainly insufficient information (code, errors recieved, ... ) to positively identify a correction.

MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over

 

[SgtJarrow]

Also, try changing your IF line to:

If rs.EOF = True Then Call Monthly_Contribution_Amount_AfterUpdate

Notice the Call.... Please remember to give helpful posts the stars they deserve! This makes the post more visible to others in need!

Robert L. Johnson III, A+, Network+, MCP
Access Developer/Programmer
robert.l.johnson.iii@citigroup.com

 

[JDRoss]

rs.Nomatch seemed to solve the problem. Interestingly!

Thanks for all your help once again

John