If Is Not Nul, i.e. if there is data in the field, then go to new record.

D

Dave Elliott

I need for this code to go to a new record if there is data, i.e. a customer
in the opening record.

Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "BlankChecks"

If IsnotNull(Me.Customers) Then
DoCmd.GoToRecord , , acNewRec

End If

--


---------------------------------------------------------------------
This email and any files transmitted with it from Dave Elliott are
confidential and intended solely for the
use of the individual or entity to whom they are addressed.
If you have received this email in error please notify the
sender.
All Mail is pre-scanned with Norton Antivirus 2004 for your protection.

http://[email protected]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Select More Than Record at a Time Question ??? 0
Open form from another form Via Code 1
See Code Below, Need to Print out ALL Records, How??? 1
Split Database Question ??? 1
How to go to new record when opening form from command if no link 7
Access Number for Colors, ? 1
See Code Below, Need to Select ALL instead of just one, ??? 5
Go to a new record on another form? 6

Top