I am trying to create a second combo box where the values change dependent on
the entry in the first combo box.  i have tried using the MS Online help
example but the code just isnt working for me on MS Access 2003.
Can anyone offer me a solution?   first combo box name: "cbosite" ...

I have a form that needs another form to be open for it to work. What I want
to do though is when the user closes one of the forms both close.
I have it working with one of the forms, but the user must close that form
first. If I add the same to the other form I get an error as it ...

How do I break this into seperate lines, I'm trying but I can't seem to
get it.
Thanks
DS

I have a table with a field that is currently defined as text in a table that
I'm linking to.  Recently I was requested to transmit a batch count that
would multiply this text field by a quantity field to provide an additional
check for the batch submitted.

Is there any way that I can limit the data that a for shows based on a combo
box on the form?
I want the user to select a year from the combo box so they only see that
year's data.  I also have a-z and all buttons along the bottom of the form to

I have a combo box in a form which is used to select records from a
table for the purpose of editing or changing. I also want the user to
be able to create a new record by inputing a new reference number in
the combobox. For this purpose I'm using the NotInList event which

Good Morning Everyone,
I'm making a database and I'm playing with it using test data. When
I want to put the actual data in, how do I reset the autonumber back to
1? How do I tell the database to completely delete the fake records so

Hi, I have a fairly normalised table.
Contacts Table
Contacts ID
etc

I'm coding for a message box to pop up should a particular form control
be blank.  For reasons too long to explain I'm not using "Is not null"
for the form validation property nor am I using table level validation.
I'm doing all this at Form Unload.

I have a subform that I would like to initially populate with
pre-existing data based on a SELECT query.  However, I also want the
user to be able to either add to or edit this data on the screen
without immediately affecting the underlying tables.

As I understand it having public constants or variables is not a good
idea.  So I coded a function instead -- I have a set of hexadecimals
for use in an API function.  Instead of using the hexadecimal value in

Can anyone tell me how I can programatically highlight the current record in
a subform - in datasheet view. (as if I had clicked on the record selector on
the left-hand side of the datasheet).

how to highlight a text in color on checking on the checkbox ?
thanks

I have a calc for each returned subform row (continuos form)..can i sum these
calc'd fields? I get an error summing the text box in the subform's footer..
Thanks!

I am learning how to use a list box contained in a form as part of a WHERE
clause;
Is this the right code? When I click on the command button and select the
itmes I want used within my WHERE clause I only get blank records in the