I'm looking for one line of code to jump keyboard focus to a particular
field within a form, which I can put inside my oncurrent event?
My control name is NAME.
tia for your help/.

I want the control wizard to create VBA code, not embedded macros.  I checked
the "Always use event procedures" box in the Access Options - Object
Designers, but the wizard still creates embedded macros instead of VBA code
(tried several combo boxes and command buttons on ...

I have a subform that when you double click on the lastname it brings up
another subform.  This works fine, however when I double click on the
lastname a parameter box appears requesting that the lastname is typed in,
then press okay.  Below is the code that I am using to ...

Getting frustrated.
Any way to use the GotoRecord Method without referencing the form name.
If the form is already open why the need to referewnce????
James

I read an old thread from Allen Browne who replied to a question of
incrementing number using the year and sequential number.  
This is the suggestion Allen provided on 8/18/2006 (subject: Incremental
number):

What code do write when I want to cut form a text box on my form and paste it
in a subform on my form ?

I'm trying to create a Named Range called "DataRange" based on my values as
listed in LISTING 1. For example, "DataRange" would currently be B2:B10. The
trick to my problem is I will be inserting a row after Row 1 with code, thus
shifting "DataRange" to B3:B11 for example. The ...

Hello.  I am trying to draft an if/then statement that will pull a
rate from a table and use it to multiply by a number from a different
table.
Table:  ExpensesMain

I have three fields ([Intime], [Outtime] and [DailyTotal] in a sub form, all
set as short time format.
The dailytotal field calculates the difference between the out time and the
in time fields. This gives me the time worked for that day or period.

I'm sorry to bother you guys with probably one of the most obious questions
in Access. but here it goes.
I already see the advantages of working with forms with unbound recordsets,
like adding records, modifying, deleting and so on.

I have this issue with a laptop computer (A - Office2003 with Access2000),
where I have a database application. I have a work copy of the db on another
machine(B - Office2000 with Access2000). I created a form with some coding on
machine B and compiled it. I imported the form ...

i have a form whose records can be filtered based on the value of a combo
box (on that form) (cboSourceFilter)
the combo box gets it's values from a user entered table
my problem is:

This question could apply to a form or a report.
I frequently do reports where I populate a table that will be form or report
data source.  The fields hold data for time periods - e.g. month, week, day.
I want to dynamically change the field captions to display correctly on a

Hi All,
Getting close I think. I have an unbound text box on a subform that lists
items from a table (tblSENEIncidentLog2008).  The subform is on my Main Form.
I am trying to make it so when I click on an item from my ListBox, it loads

Hi, thought I had seen something similar several months back but can't find
anything on it today.
We have a few items in a combo box that users should not use anymore for new
records, but some old records still need to display them.  The vehicle types