Greetings all.  Is there a way to change the on click event of a command
button with the on click event of another command button?  I am using Access
2003.  Hypothetically, If I have cmd1, cmd2, cmd3 and cmd4 is there a way to
have the on click event of cmd1, cmd2, and cmd3 to be ...

Intially I pass the employee ID to a popup form to edit the employees family
particuplars. What I would like to do is when the user closes the popup form
using the close button, that the record pointer on the parent form is the
record the user intially clicked. So basically have ...

Good morning everyone,
First off I need to thank Marsh for giving me the outline for the
following code, I would not have been able to continue with this
application without it.

I am using Access 2003.  I ultimately want my information for a report
but here is my scenario.  I have a database set up with a table of
customer accounts and a table of mutual funds held in each customers
account..   So customer a holds 3 mutual funds and customer b hold 5

I would like to hid a subform when a user clicks the top meny of a tab (the
actual tab desciption.  However, this does not work.  The onClick even is
only activated when the user mouse down's on the inside of the tab control.
This is pretty useless as I dont want the user to see ...

I have 3 cascading combo boxes that need to be bound to a sub form linked to
the values selected in the combo boxes.
Any suggestions or examples would be appreciated.

I am trying to use a textbox to show data retrieved from a table after
the user makes a selection from a combobox.  I am using the seek
function and everything seems to be working fine.  The variable I am
using has the correct data according to the locals window, but I cannot

Greetings!  Thanks in advance for any help.  I have been teaching myself
access as the programmer we hired for our non-profit group went AWOL with an
incomplete project.
I have a form in which I have several unbound combo boxes which I would like

In debug mode I understand that during a error, if you hit reset you can lose
all your global and module variables.  To quote from the help info, reset
does the following:
"Clears the Call stack and clears the module level variables."

Hi
I'm trying to open an existing record in an amendment form.  
The user enters the ref_number in form with a text box and button and this
opens new form passing the ref_number as OpenArgs.

I have a form which shows contacts. There is a listbox which has the type of
contact as each contact may be in more than 1 category. I want to be able to
hide certain cantacts when the form opens and therefore was looking to filter
on the list box. The list box has 2 columns and ...

Good Morning,
I am finally creating that last part of app...what I am trying to do
is create a command button that will print a report for any record
that is older than six months. I am sure that this is an easy

I have a database form based on the Contacts Management template mdb.  What I
am trying to do is add a control to the Contacts Form where I can Drag and
Drop an item such as a *.pdf or *.doc  (for example a resume).
The desired behavior would be to go to the form and double click ...

I am trying to automate the process of having a data entry clerk enter data
into a form and to have her just enter shortcut keys to do tasks like close
the form or to open specifc tabs.
How would I code this into the page so that she could just do simple key

I generated the standard duplicate button from Access; I used it in another
form and it works great; in this other form I can't get it to work right for
anything. I checked all the settings of what I did in the previous form and
everything is the same; however I do have a field ...