Re: How to input different data in combo / check boxes for datashe

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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).

--
Duane Hookom
MS Access MVP
--

"Belinda Cox" <BelindaCox@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:08262123-D57C-4E50-944F-57DF316D3839@xxxxxxxxxxxxxxxx
> 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.
>
> "Duane Hookom" wrote:
>
>> I assume by "data***", 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?
>>
>> --
>> Duane Hookom
>> MS Access MVP
>> --
>>
>> "Belinda Cox" <Belinda Cox@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:FA468C13-FFBA-40B2-830C-5F623C8B249C@xxxxxxxxxxxxxxxx
>> >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 data***. (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.
>>
>>
>>


.

Quantcast