Is it possible to determine which object on a form is currently selected,
and have the name of the object placed in a variable string.  For instance if
I had a combo box called combo1 and someone updated information in it, how do
I get the name of the combo box in a string named ...

When I use Recordset.State Property in module - OK. In form code I have an
error - object variable is not set. I Have declareed the recordset: Public Rs
As Recordset.
Please help: what is the right way to find in form code the state of

According to my research, VB error 80004005 (-2147467259) is an "Unspecified
Error" - which isn't exactly helpful <grrr>. The error description in the VB
error pop-up is a bit better, giving "Method 'Open' of object '_Recordset'
failed" (I mean "very little bit" better  <sigh>).

This is a repost from another section (wrong section).  
I have a txtbox on a form that the user will place an 8 place number.  In the
table it is listed as Number/Long Integer.  However, I continue to get a type
mismatch error notice.  Below is the coding that I am using.

How do I use VBA or a macro to present either a pop up form or inpu
boxes to accept and validate the dates, then call the queries using th
dates entered as parameters? The dates are popping up for both the quer
and my event. How can I sync both to work together? I current have th

I'm new to access but have a programming background. My question is what VB
code is needed when I use a value from a linked table (CustID) as the value
in the Combo Box to access another table (Call Tracking) which may have
multiple entries for the CustID. I want to be able to ...

I'm using Access 2002 and I'm creating a database to assign vehicles. I have
a query that displays when vehicle1 has been assigned. Is it possible to
place a calendar control on a form and sync it with the vehicle1 query? So
all the user would have to do is click on a date to see ...

I am using access as a front end to sql server backend. I have a form with a
subform and when the form is getting loaded I am assigning the master form
with the field values by using a query to populate fields from sql.
Now I want to assign values to subform using the same query. ...

Is there a way to write an If then else statement like
If text20.value = "A" or "B", then
do something
else

Tina, again thanks for your help.
See if this is possible:
Here is the VB script:
Private Sub Form_BeforeUpdate()

I took the oh-so-subtle advice of posters here and downloaded and used
Stephen's calendar, even though I had very little understanding of how it
worked.  It worked great!  (Stephen, you rock!)  I tried it again with
another database, and I get an error (ByRef argument type ...

When I add entrys using the form veiw, and then close out the form veiw, I
can not see that entry (it goes back to entry 1 for the new entry) but I
could see the added entry in tables veiw.  Is there any way to veiw/edit the
previous entrys in form veiw?

MS Access 2000, Win XP
===================
Hi,
This is probably quite simple, but I'm totally missing it, and need some

I am running a small timestamping script and after calculating and
putting in the updated timestamp, the form freezes.  I can only
unfreeze it by hitting the 'esc' key.
Here is the VB script:

VBA Programming; How can I cycle through a record set and retrieve the field
name and the value for each field and store the information into an Array?  
The purpose is to find out if a value is missing or is not the correct, if
the previous statement is true, then give me the ...