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
|
|||
|
|||
Options should apply to one record- not all
For example, in a database of outstanding issues I created the option buttons
in the design form (option buttons are where you have the circles where one can be selected and not the others). I need to have this information for each individual issue, or record as Access calls it. However, when I click the buttons, it applies to all of the records, not just the one I intend it to apply. How do I change that? |
#2
|
|||
|
|||
Do these buttons correspond to fields in your table? Are they linked to
those fields? Access can't remember (store) the value if you don't have that value tied to a field in a table. An unbound field will have the same value no matter which record you look at. Rick B "blondtraillite" wrote in message ... For example, in a database of outstanding issues I created the option buttons in the design form (option buttons are where you have the circles where one can be selected and not the others). I need to have this information for each individual issue, or record as Access calls it. However, when I click the buttons, it applies to all of the records, not just the one I intend it to apply. How do I change that? |
#3
|
|||
|
|||
On Fri, 18 Mar 2005 12:21:02 -0800, "blondtraillite"
wrote: For example, in a database of outstanding issues I created the option buttons in the design form (option buttons are where you have the circles where one can be selected and not the others). I need to have this information for each individual issue, or record as Access calls it. However, when I click the buttons, it applies to all of the records, not just the one I intend it to apply. How do I change that? It sounds like your Option Group control on the form is unbound - i.e. its Control Source property is blank. If you want it to apply to each record, you must have a Number (integer or long integer) field in the table, and the option group control needs to be bound to that field. John W. Vinson[MVP] |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Prevent Blank Records being written. Need Help. | Robert Nusz @ DPS | Using Forms | 4 | December 29th, 2004 05:15 PM |
Automatically displaying a certain record of a query | General Discussion | 1 | December 12th, 2004 10:08 PM | |
Form drops edited record-inserts new record instead | karenk10 | General Discussion | 0 | September 22nd, 2004 10:19 PM |
Form Doesn't Go To New Record | Steve | New Users | 15 | May 16th, 2004 04:33 PM |
Form Does Not Go To New Record | Steve | New Users | 1 | May 12th, 2004 03:15 AM |