Ken-
In the Form_Current event, perhaps something like this:
If Not IsNull(Me.PayDate) Then Me.Amount.SetFocus
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of kenaf42
Sent: Saturday, July 27, 2013 10:36 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Access 07 Conditional GoTo Or SetFocus
I have simple Form in Access 07. First two fields are Date and time. While I
am adding records by using the following procedure in beforeUpdate event
If Not IsNull(Me.PayDate.Value) Then
PayDate.DefaultValue = "#" & Me.PayDate & "#"
End If
I import or copy data from previous record to the first two fields (date and
time). The 3rd field is amount, what I want to do is that when I am done
with first record and go to fresh page to enter new data mouse curser would
bypass the first two fields and go to amount field because date and time
fields are already filled. Please help with procedure.
Ken
------------------------------------
Yahoo! Groups Links
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar