A new problem!!! 1

[rdkirb49]

I have to limit a box to only certain letters. I have no idea where to start. Is there anyway to have the user just click a box? Please help!!!!!!!!

Reg

 

[rdkirb49]

I guess what I am trying to say is, I need a check box linked (bound) to a field in my table so when the user clicks a box it will register in my table. I hope that is a better explanation.

Reg

 

[scriverb]

If you form is a bound form meaning that the RecordSource for the form is your table or a query which displays your tables fields then use the CheckBox control from the Toolbox. Create the control with the label. Change the label to the name that you want the user to see. Now change the Control Source property of the CheckBox control to the name of the field in your table. You can just pick it from the dropdown list of possible fields.

Post back if you need more help.

[COLOR=006633]Bob Scriver[/color]

[COLOR=white 006633]MSU Spartan[/color]

 

[scriverb]

One more think, this field should be of the Boolean type in your table. Because the value of the check box will be Checked(true/ -1) or Unchecked(false/ 0).

[COLOR=006633]Bob Scriver[/color]

[COLOR=white 006633]MSU Spartan[/color]

 

[rdkirb49]

How do I know if it is boolean?

 

[scriverb]

Open your table in design view. Select the field from the field list. You will see a column to the right of the names. This column designates the TYPE of field. It should say Yes/No. This means that the selection of Yes or True is stored as a -1 and the selection of No or False is stored as 0. This field may be checked for any of the above values.

Post back of any questions.

[COLOR=006633]Bob Scriver[/color]

[COLOR=white 006633]MSU Spartan[/color]

 

[rdkirb49]

How can I link this to a form??? I have the check boxes on the table but I need it on a form so the end-user can't see the table and possibly change data..

Reg

 

[scriverb]

In the database design window select Forms. Now select the Forms Wizard. This will walk you through creating a Bound form. A prompt will ask you for the underlying Bound table for your form.

This should get you started.

[COLOR=006633]Bob Scriver[/color]

[COLOR=white 006633]MSU Spartan[/color]

 

[rdkirb49]

Can you say DUFUS again.... The problem was that I wasn't clicking the checkbox to get the control source... I was clicking the label..... Oh' well..... By the way,,, where's that TT button to remove a thread ... You guys are really a life line. I thank all of you so much!!!!!

Reg