My mainform lookup combo (cmbJobfind) finds a subform record based on
selection and works great until I click on a subform record then it stops
working but gives no error. If I change the mainform record the combo values
change (as they should) along with the records displayed in ...

I have tried using this code on my form to trap Required fields being left
empty. It does not work properly though, it is a continuous form - could this
cause a problem?
Three of my text boxes have a Tag of Reqd, values for them have to be

I am trying to setup a Search Button with four possible variables.  The
results need to show all records containing the variables entered.
I have four different tables in my database and a main form that allows the
person to add new records or search the four queries.  The person ...

Does anyone know how I can make this code trap for the Last Record
The procedure cycles through a number of the same selection box on one
continuous form, and if the choice is correct, then copies the data to
another field on the target field/form. Then moves to the next selection ...

I have a form that the users want to use to send out a list of emails.  What
they are asking for is a textbox that will provide them with the total number
of emails that are marked for sending and as well as a a counting process
that tells them how many of them are sent until all ...

Hi, I have an access 2003 form with a tab control. A listbox allows users to
move from one record to another. Even using Application.Echo off before
moving to the selected record there is still a screen 'jump' at
Application.Echo on. That is even though the position of all ...

If I turn off record locking and set db to shared on the front-end and
back-end, when the users open the front-end should it also open a .ldb copy.  
My thinking was you got a .ldb copy when the db was set to exclusive and/or
edited record locking it turned on.  I have about 15 ...

I'm looking for a proper way to do something that i think is probably simple.
Lets say frmA has cboA, whose AfterUpdate event is used to populate the
form.  Similarly, frmB has cboB, whose AfterUpdate event is used to populate
the form.  

I have a table with the sales information. The form will run a query and list
the Sales and commisions earned by the sales persons. Commisions are paid
after 2 months of sales. A query is run by specifying a sales person name and
result is posted to form as shown.

Is it possible to programmatically create a control on one of the pages of a
tab control in a form?
Thanks,
Rocco

I have an off the wall question and this is probably the wrong place to
address so I apologize in advance.
When I am working on a form I need to move the fields around to make
everything somewhat uniform. Sometimes, I may need to move the field ever so

Hi. I have a combo box to find an exiting member:
Private Sub CmbSearch_AfterUpdate()
   ' Find the record that matches the control.
   Me.RecordsetClone.FindFirst "[ContactID] = " & Me![cmbSearch]

When I try to run the code below, i get an error message saying
"The object 'Forms!Runs!frm_Run_Test' isn't open
I don't understand, because the form is actually open?
The code below is to take a value from one form and pass it to a control on

I have a table called Referrals.  I need to add a button to that form to
allow users to add records to table called Deferred.  Records in the Deferred
table must have a record in a table called Donors.  My problem is when that
relationship does not exist yet.

I have developed alot of forms in my databse to perfectly fit the screen
when I open them as maximized.  Now I have 2 users that are going to move to
widescreen laptops.  That pushes the form to the left and it leaves the
screen looking really funny.