How to input different data in combo / check boxes for datasheets

B

Belinda Cox

I am very new to Access and have managed to set up forms using the wizard. I
have set up both Combo Boxes and Check Boxes in the design view however when
I go back to Form View to check the boxes, it checks the boxes on all of my
entries instead of just the one datasheet. (E.g. I would like to check a
Mailing List box to add customers onto the mailing list. If I check the box
for customer 1, it checks the box on all of the customers.
 
D

Duane Hookom

I assume by "datasheet", you actually mean a single record. If you want to
store a value with a particular record, there must be a field in the record
to store the value. Are you check boxes bound to a field in a table/

What are your significant tables and fields? How are they related?
 
B

Belinda Cox

Duane,

Sorry but a lot of what you are saying is way over my head! I am extremely
new to access.

I am using access to list my clients names, addresses, telephone numbers
etc. which was very simple. I now want to record what products each customer
buys and whether they would like to join my mailing list. I do not believe
that this requires having them bound to a field in a table. But please
correct me if I am wrong. I had created check boxes and a combo box which
are unbound. Is this the best way of recording this sort of information?
Perhaps there is a more suitable way of doing it.

The main problem that I have is that when I click on the check box / combo
box on a single record, it places a check in all of the other records.

The Combo Box that I have created is one column and the variables are yes
and no. Each time I select yes or no in a single entry, it places the same
answer in all of the other records

Does this make any sense to you? Sorry, I know that we seem to be talking
in different languages.
 
D

Duane Hookom

You state "I now want to record what products each customer buys and whether
they would like to join my mailing list". This suggests that you have a
table to store the information. If all you would EVER have is one mailing
list, you could add a yes/no field to your client table. Then add a check
box to your client form. Make sure the check box has a control source of
your Yes/No field.

If you want to store products each customer buys, this information should be
in your sales table(s).
 
Top