Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 03-18-2009, 02:11 PM   #1
mitch_johnson
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
speakers_86
I am jack's comment.
 
speakers_86's Avatar
 
Join Date: May 2007
Location: JBLM, Wa
Posts: 1,919
Thanks: 11
Thanked 160 Times in 119 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
me.yourfieldhere.setfocus
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
Reply

Tags
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 12:42 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


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