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
|
|||
|
|||
Field list greyed out when trying to add an option group
G'day All,
I have been having heaps of trouble trying to associate an option box with a field in a table. Not sure whyI am unable to achieve this as all the tutorials I have seen have a very simple description on adding the field. When I insert an option box I don't get the otion of selecting a field to bind to. and when I have inserted the option box the viewfieldlist is greyed out. I have a number of tables in teh database some with data and some without. Any help on this would be greatly appreciated. Tony |
#2
|
|||
|
|||
Field list greyed out when trying to add an option group
Tony,
There are two ways to do this: 1. Binding the Option Box to a field in the form's RecordSource: With this option, the Option Box must be bound to a field that is in the table/query to which the form is bound. For example, if the form is bound to tblMyForm, then the Option Box can be bound to any field in tblMyTable that returns a Boolean value. To bind a form to a specific table/query: a). Open the form in design view. b). Open the Properties dialog (right-click and select Properties from teh context menu). c). Select the Data tab. d). Select the appropriate table/query from the RecordSource drop-down. That's it! To bind a control to a specific field at the time you place it on the form, do the following: a). From the View menu, select Field List. The Field List is displayed. b). On the Toolbox, click the type of control you want to add (in your case, an Option Box). c). In the Field List, drag the appropriate field to the form. That's it! To bind a control to a specific field after it has been placed on the form, do the following: a). Click the appropriate control. b). If necessary, right-click and select Properties from the context menu (to display the Properties dialog). c). Select the Data tab. d). Select the appropriate field from the ControlSource drop-down. That's it! 2. Binding the Option Box to a field in an unrelated table: With this option, the Option Box can be bound to any field in any table (as long as that field returns a Boolean data type). To bind a control to an external field: a). Select the appropriate control. b). If necessary, right-click and select Properties from the context menu (to display the Properties dialog). c). Select the Data tab. d). Click inside the ControlSource field (but don't drop-down its list). e). Enter the following: =DLookup("myField", "myTable", "somecriteria = met") *** Naturally, change the above values to suit your situation. That's it! Regards, Graham R Seach Microsoft Access MVP Sydney, Australia Microsoft Access 2003 VBA Programmer's Reference http://www.wiley.com/WileyCDA/WileyT...764559036.html "Tony" wrote in message ... G'day All, I have been having heaps of trouble trying to associate an option box with a field in a table. Not sure whyI am unable to achieve this as all the tutorials I have seen have a very simple description on adding the field. When I insert an option box I don't get the otion of selecting a field to bind to. and when I have inserted the option box the viewfieldlist is greyed out. I have a number of tables in teh database some with data and some without. Any help on this would be greatly appreciated. Tony |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Option buttons and tabs | Aniko | Using Forms | 14 | June 24th, 2004 05:32 AM |
option group | troy | Using Forms | 4 | June 23rd, 2004 11:51 PM |
Linking Option Box to Form Field | judy R | Using Forms | 1 | June 9th, 2004 09:25 AM |
List Containing Instances of Numbers in a group | MrvinGover | Worksheet Functions | 1 | January 20th, 2004 06:27 PM |
Adding Option Buttons to a Group Box | Sandy | Worksheet Functions | 1 | September 28th, 2003 12:13 AM |