I have a form 'Home Dept' that opens from autoexec that has a combo box bound
to a table column called 'HomeDeptID' that has 2 choices Sales or Purchasing.
I want the combo box to open and filter a form that uses the ID from these
choices to limit the records shown to the homedeptID ...

Hi. How can I insert a control inside a tab control. I insert a tab contril
in my form. The tab control has two tabs, in one tab I want to place a
subform, how can I do it?
Regards,

I got a requst for the colors to change on a form if a certain check box is
checked. So I have two check boxes. I have a domestic check box and a
International check box. When someone checks the domestic check box I want
the background of the form to change white and if someone ...

I have a main form called [frm x main], on which there is a subform (in
datasheet view) called [qry x main table subform].
After entering data into [qry x main table subform] the user clicks a button
on [frm x main] to run various queries.

I'm trying to enter a records into a form on an Access 2000 database and
every now and then it comes up with a message that says: "Bookmark not
Valid".  Its only just started doing it - up to now its been working just
fine

Access 2000
First Table:
LogID                         (AutoNumber) Primary
Auditor                       (Lookup to Auditor Names)

When I click the command button icon in the Toolbox and make the size
of my command button it used to pop up a wizard with several option,
like Quit application, Go to the following form, etc. Several option to
choose from. But now when I create a command button the pop up wizard

I have a table Prospect Tbl that draws input from 3 other tables (using
the Look Up function in the table's design view). Then, I have a query
Prospect Qry that puts this table together with another table New
People that also draws off a few different tables. I want to create a

I've read the Microsoft Office Online help at
http://office.microsoft.com/en-us/assistance/HA011730581033.aspx, but I can't
figure it out.  I'm a "Newbie" at this.
I have a Lease Management database with over 100 stores.  Those stores are

I made a subform and for some reason linked the names from one table to the
next. Now I am having trouble with duplicate names.
How do I correct this and sync up to keep the correct data? Do I need to
make a new subform? Do I need to change the tables?

I have a database that I want to use to track corporate records.
Others have determined that they want to use a key field that is a six
character date (like 092006) followed by a four character number (like
0001).

I am creating a work database and we use codes for customer's and their
information so I want to be able to enter a code that relates to a customer's
name, address and postcode.  When the code is entered or selected from a list
(in a form) I want the related customer's ...

I did what was recommended below but am having an issue.
How do I incorporate the delivydname(tried adding it as a primary key and
get no records on the query)
I believe this should be Client specific. I am having an issues with having

how can I make sure input in a text box would be like following:
xxxx/nn  where xxxx is a number and its number of digits (one digit or more)
may vary and the nn is two digit string (number that may start with zero)
thanx

i hav a field which is in subform. i'm named it as location. when user change
the location and i want to know and i want the record to keep it in a table.
i want to know when the user change the location n where they put the things
now. what i can do? thanks!