Return to top

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Slp - 06 Feb 2004 23:22 GMT

I have a database that has about 15 fields in it. for the
most part I only use the first 8 then I click on next
record to continue adding records but the cursor stays on
field 8 is there anyway to make the cursor go to the first
field for every new record?

Thanks
Lynn

Reply to this Message

Bruce M. Thompson - 07 Feb 2004 00:14 GMT

> I have a database that has about 15 fields in it. for the
> most part I only use the first 8 then I click on next
> record to continue adding records but the cursor stays on
> field 8 is there anyway to make the cursor go to the first
> field for every new record?

In the form's "On Current" event procedure, you can use code something like
this:

'***
'If you want to move to the first field on every record change
Me.ControlName.SetFocus

'If you only want to move to the first field on a record change
' when you have moved to a "new" record
If Me.NewRecord Then
Me.ControlName.SetFocus
End If
'***

You would need to replace "ControlName" with the name of the control that
represents the "first" field on your form.

Signature

Bruce M. Thompson, Microsoft Access MVP
bthmpson@mvps.org (See the Access FAQ at http://www.mvps.org/access)

>> NO Email Please. Keep all communications

within the newsgroups so that all might benefit.<<

Reply to this Message