Special thanks to John W. Vinson & Arvin Meyer
Thank you for your help to me
I'm very happy

I need to automatically lock a field after it's been written into and
has lost focus.  Right now I'm using a checkbox, but I want to lock
automatically once the field is dirtied (written into) and it loses
focus.

THis is a very basic question, since I'm learning Access without a
book, so don't read too much into it, and from my description I trust
you understand where I'm going.  This post is a repost of another
thread that got rather long so I broke it into a new post.

Due to the peculiarities of my database design, I only can enter one
row (record) at one time for a particular subform.
If you try and enter more than one record, you get an error, and you
have to hit the escape key.

In a search form, with a sub form (table filtered), I would like to be
able to modify a field by clicking a button.
This is the kind of file that I use. Http://allenbrowne.com/ser-62code.html.
I have this procedure, but it does update only one record.

Happy Holidays/New Year to all:
I am building a database to catalog my videos and DVD's.  Getting all the
info from either the pamphlet or end of the movie is getting rather tedious.  
Is there anyway to get the info directly from IMDB for video and CDDB for

How many table can I make relation between them in Query Design view?
Because this message appear to me after I add 3 table only
The SQL statement could not be executed because it contains ambiguous outer
joins. To force one of the joins to be performed first, create a separate

At the moment, when I hit the arrow button on the combo, the drop-down list
appears directly below the combo-box control.
I want to have my drop-down list left edge appear on the right of the
control. Is this possible? I am using Access 2007 and have looked at all the

I have used Albert Kallal's multi-select (
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html) example to
select records on a continuous form and have them displayed on a report.
Is it possible to use similar logic to Albert's multi-select example to

First off, I'd like to thank you all for assisting me in this matter.
I'm atrying ot open a forum from another form with multiple matching criteria.
Here is the code I have thus far...
   stLinkCriteria = "[WO_ID]=" & "'" & Me![ID] & "' And [WO_CorpID]=" & "'"

I'm using access 2007
I have this 2 table for (example)
First table
IDPlayer               AutoNumber

Can any MVP tell us:
What is the step needed to be Expert as MVP (in Access) ?
Can any MVP tell us the story How he began and how he become Expert in
access..

How can I take an action (Example: Display a measssge box ), if the user
clicks Cancel in the Open Dialog.
I got this API to work, but I know very little about how to manipulate it.
Some sample code and an indication of where to place ithe code would be very

Hello.  I am trying the following code to check for input in required fields
on a form:
Private Sub Form_BeforeUpdate(Cancel As Integer)
Dim ctl As Control

 I want to pull data from more then one field ( as it seems with a combo
box with multiple fields listed in a row ) and have it save these fields to a
diffrent table. What  I'm trying to do is take a Whole record and save that
record to a new table.