I have set up a database which has multiple tab control forms (which are
linked together) for data entry. One of them is not showing when I view it,
although it looks fine and all the fields are there in Design view. I have
looked at the properties but can't seem to figure out ...

Thank you Wayne-I-M for responding
FYI: I'm using Access 2007, and the combo boxes are unbound.  The fields i'm
using are not primary fields, and i use the Distinct key word for populating
the combo boxes, which worked in the cascading listbox example.

employee is choosen,vacation date appears then employee's backup appears
after that

I have seen several posts on this particular subject, but I haven't really
found an answer to my problem. I do not consider myself to be an advanced
user of Access, but I know enough to get me into trouble.  
I have been asked to create a database to store employee information. The

From a previous effort using Cascading List Boxes, i was able to
subsequently run a command button for the first listbox which then lists the
results in a query selection in datasheet view.
See following code.  Now i would like to run a similar query that shows the

I am trying to open a form in Access 2003, based on the criteria selected in
another form.
Here are my TABLES and fields:
SEARCH:  date, time (all text fields)

I have created a main form and subform and want to prevent Access from adding
new data into the subform until I've entered key data, like a Primary Key
(AutoNumber), into the main form. I have a main form with Writeup information
and a subform with Officer information. I don't want ...

How does one prevent a form from being changed? I am trying to have the form
open for confirmation purposes, but opening in print preview mode is not
quite what I have in mind.
I tried using a macro, setting the data mode argument to "Read only", but

I am facing some problems in binding the control source of a textbox to a
query that is NOT in the record set of Form (I don't want to change the
record set query). I want to show the course name when a user selects a
course ID

Is it possible to save the changes to a form when I make changes to the
underlying database table?  It seems that every time I add a new field or
rename a field (which I do with the database table), I have to create a new
form, and override the design changes I've made to the ...

i  have designed a form in that there are two fields called actual payment
[AP] and
commission [comm] the scenario is like this if [AP] is from 1 to 25000 - the
bank will charge 25

[Apologies if this is a duplication -- I am not sure if my previous message
was posted.]
I make changes to my Access database using the Tables, but enter data using
Forms.  I like to redesign my forms.

What I'm trying to do is, in a date field, on "has focus", if related "check
box" is positive (yes) then insert current date + (plus) 45 days. (to present
a future date).
Is there any help out there?

I want to set the focus in the one textbox even if I press <enter> or <tab>
key until I use the mouse to point to another textbox. How can I do ?
Thank you
Jason.

My company currently uses an access database to run queries, reports, etc.
from our accounting system CODA because CODA is not user friendly.  My first
question is "Is it possible?"
We are a management company that pays for our clients vendor invoices and