I have a simple (I hope) question for the group.  I have an update personnel
form with a number of combo boxes and txt boxes.  
My first combo box has names, onchange event is fired to fill the various
txtboxes  of data from the database of the selected individual.  My question

How do you requery sub forms on moving from one tab page to another tab page.
Thanks
Danny

Can anyone help me? I have racked my brain on this one.. I have my invoice
form that I use to create new invoices and when I choose my invoice type, I
get this message:
Here is the code that the error points too (at the astrisx (*) )

good day all,
 I have created a form/subform for my invoice creation, there is just one
thing that is stumping me.
 Well, first I guess I should explain one thing that is used in my subform:

Is it possible to toggle the visibility of labels on a form? I have two
labels stacked on top of each other, one is visible and the other has
visibility turned off. What I would like to do is have a user click a button
to toggle the visibility of both labels, but only have one or ...

I have a form that allows me to add data to a table. I have a Public variable
that holds a certain value from another form. When I click the Add button (

How can I do that please? I've been working on this ...

I have a table with a Primary Key (UniqueID) of Autonumber type.
Here is the problem I'm having. Sometimes, I have to delete some records
from the table, and that creates a gap in the autonumber field.
There is a control on the form bound to this field, and this is also

I would like to use a command button to count the words/spaces in a textbox.

How do I set a paramater value when opening a form which is based on a query
using a command button
Thanks
Danny

I would like to add a movie to an Access 2000 form with the intention of
creating a multimedia experience for the user. Can you please direct me to a
resource that discusses this or provide other information
thanks in advance, Barth

Ok, I want to set up a DAO transaction, which I have in my main procedure.
But if I call sub procedures, any updates there won't be included in the
transaction. I'd like to include the sub procedures, as I may need to
rollback the whole lot.

Hello;
How to Delete or Rename a table from another Database (other than the DB im
coding in),while im in the CurrentDB?
Thank you for your help.

I've experienced that if I have some controls with underlying code, and I
cut and paste those controls to ex. a tab-control (or the other way) - The
phrase "[event procedure]" in the controls' property sheet dissappears. The
code itself remains in the module, but I have to figure ...

I would like to be able to select the entire record of a
continous form when I click on any of the its fields (so
that the whole record is highlighted just like a list
box). Is this possible?

I have an access 2000 project in which I wrote the following code:
Private Sub updateChecksList(myTable As String)
   Dim rstChecks As ADODB.Recordset
   Set rstChecks = New ADODB.Recordset