If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Tick boxes
I have a form which includes a column where the user selects a tick
box and this automatically fills in there name and date on another part of the form. The problem is if I tick say row 1 the name and date appears as it should in row one but also ticks appear in the tick box column for various other (random i think ) rows although the name and date information does not, can anyone explain why when i tick one box others in the column fill themselves in. Being self taught my knowledge is limited Thanks in advance |
#2
|
|||
|
|||
Tick boxes
Paul,
That's because the checkbox control is not "bound" to any table field, so it's value will be reflected in all your continuous form records If necessary, add a field to your form's underlying table, (ex. FillInName), add that field to the query behind the form, and set the ControlSource of your checkbox to FillInName. -- hth Al Campagna Microsoft Access MVP http://home.comcast.net/~cccsolutions/index.html "Find a job that you love... and you'll never work a day in your life." wrote in message ... I have a form which includes a column where the user selects a tick box and this automatically fills in there name and date on another part of the form. The problem is if I tick say row 1 the name and date appears as it should in row one but also ticks appear in the tick box column for various other (random i think ) rows although the name and date information does not, can anyone explain why when i tick one box others in the column fill themselves in. Being self taught my knowledge is limited Thanks in advance |
Thread Tools | |
Display Modes | |
|
|