A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Field list greyed out when trying to add an option group



 
 
Thread Tools Display Modes
  #1  
Old July 1st, 2004, 03:03 AM
Tony
external usenet poster
 
Posts: n/a
Default 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  
Old July 1st, 2004, 03:40 AM
Graham R Seach
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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 07:27 PM
Adding Option Buttons to a Group Box Sandy Worksheet Functions 1 September 28th, 2003 12:13 AM


All times are GMT +1. The time now is 10:01 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.