Go Back   Access World Forums > Microsoft Access Discussion > General

Thread Tools Rate Thread Display Modes
Old 03-18-2009, 02:11 PM   #1
Registered User
Join Date: Mar 2009
Posts: 40
Thanks: 0
Thanked 0 Times in 0 Posts
mitch_johnson is on a distinguished road
How to select a field on cue

hello i am new to access so please could you explain things step by step:

what i would like to do is have access click in a field in my form when the form opens up so basicly on the on open propertie does anybody have any code for that thanks

mitch_johnson is offline   Reply With Quote
Old 03-18-2009, 03:02 PM   #2
Newly Registered User
speakers_86's Avatar
Join Date: May 2007
Location: JBLM, Wa
Posts: 1,919
Thanks: 11
Thanked 161 Times in 120 Posts
speakers_86 will become famous soon enough
Re: How to select a field on cue

Open the form in design mode. Open up the properties sheet. Scroll down to on open, in the drop down, select event procedure. Then click the elipses. In the window that pops up type this code. me.YourFieldHere.setfocus. Heres what it should it will look like.

form_on open
end sub

Close this window, and thats it.
If you look, you can find anything.
Google is your friend.

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Access 2010 screw this! I went back to 2007
Windows 7
speakers_86 is offline   Reply With Quote

click , forms , open , visual basic

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Trying to return specific fields from multiple tables ctbfalcon Queries 1 02-10-2008 07:57 PM
Trigger code for Audit Trail ozinm SQL Server 1 01-03-2008 08:30 AM
[SOLVED] Can this be done?? Taiisien Forms 1 07-28-2005 12:02 PM
Select Fields but Sort by another Field Maldrid Queries 2 02-17-2004 07:49 AM
Select the record with the largest value in Field 1 for each ID jeffcullina Queries 5 05-07-2002 09:59 AM

All times are GMT -8. The time now is 10:30 PM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post

Sponsored Links

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World