Re: check boxes

Thank you very much for your help. It seems to be working ok. Have you perhaps read my thread for "combo Box" I am having trouble with my "jobs" form. I select my client from the drop down list, and then that specific client's vehicle reg details appear in the "VehicleReg" drop down list, where i choose a vehicle. This works well, but then if for example I would like to add new vehicle details for the selected client on the "jobs" form, I click on the "add vehicles" button which takes me to the vehicles for that specific client. However, it is not saving the new vehicle details which i add there. i can only successfully save vehicle details in the vehicles subform on the clients form

thank you

Melissa

"Beetle" <Beetle@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:BE845803-70B5-4E3B-99CA-6E28293729D1@xxxxxxxxxxxxxxxx
Ah yes, I saw that thread earlier. Unfortunately, as Tom said, there is
no good built in way to do that. In order to do it like you are attempting,
you would need, for example, another table with a field for each one
of your check boxes. It would need to be related to your current table
via ClientID (or whatever the PK is), an then you would probably want
to make your "wind screen" a subform.

I am *not* recommending that you do it, because it's not very good
design. For example, if you have 30 check boxes, then for every record
in this new table, you will have 29 unused fields.

But, if you are determined to proceed with it, you will need to do
something like that.
--
_________

Sean Bailey


"Melissa" wrote:

Im desiging a database for a windscreen repair company that repairs
windscreen chips

I have a form on which I select clients, vehicle details etc for the "job" -
its a "Job" form

Now, on this form I have drawn a picture of a windscreen - just like a
rectangle type shape...and I have inserted a lot of check boxes inside the
"windscreen" to indicate where the chips are located on the
windscreen, so by "ticking" the box on a certain area on the windscreen, the
user can save the location.

Melissa


"Beetle" <Beetle@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:553B0D92-4D69-4222-9F51-2597BB87A84C@xxxxxxxxxxxxxxxx
> The value of the check boxes will not be saved unless they are bound
> to fields in a table.
>
> What is the purpose of the check boxes you are adding?
> -- > _________
>
> Sean Bailey
>
>
> "Melissa" wrote:
>
>> Hi there
>>
>> I have a form with some fields on it. Now i would like to add a few
>> check
>> boxes to my form. but when I check
>> them, they are not checked when i return to that specific record?
>>
>> Please could someone assist me
>>
>> thank you
>>
>> Melissa
>>
>>



.

Loading