473,327 Members | 2,069 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

Combo Box Options Group

Hi there I am currently making a sub form. The form will have a combo box and a option group. The combo box contains a list of four employees. The option group has to radio buttons labeled Active and Inactive. These radio buttons will show the status of each employee.

However, how can I show the current status of each employee. For example, If John smith is selected in the combobox, his current status shoudl appear in the radio buttons and the user should be allowed to change it.

The table for this subform is as follows
ID -> Autonum
EmployeeName -> text
Status -> True/False

Any help will be much appreciated

Thanks
May 15 '06 #1
6 2765
wlc04
70
Mickey,

When you add the option group to the form it should take you through a wizard which will help you set it up. Note: The values that you see in your table will not be active/inactive, but rather 1/2.

Let me know if you need anymore help.

FYI: I posted a solution for you to your other post regarding this same thing using combo boxes, if you're still interested in that option.

Wendy
May 15 '06 #2
Thanks Wendy,

I got through the wizard part. However what I am having trouble grasping is how to link the value in the option group to the value in the combo box.

So if John smith is selected in the combo box. How will his current status be displayed in the option group.

Thanks again for your help
May 15 '06 #3
wlc04
70
Because the fields are related in the table, the values on your form will change accordingly. Make sure your combo box source is the Emp Name and the source for your option group is the status field. In other words, if you choose Emp A and they are active that is what you will see on the form; if you change them to inactive, your table data will change. What you need to pay attention to so it doesn't confuse you is the values for the option group - remember these will be 1 or 2, rather than active or inactive, so that is what you will see in the actual table, but you will read active or inactive on the form. If the table is not prepopulated with the 1 or 2 value, that's okay. You can make the selection from the form which will populate the table with the appropriate data.

I suggest playing with the form and data a little to get used to it. Pick an employee, set their status in the table, then look at your form; change the status on the form and go back and look at the table. Once you see if a couple of times, it'll make sense.

I've got a table and form made here I can send you if you need it. Let me know.
May 15 '06 #4
Because the fields are related in the table, the values on your form will change accordingly. Make sure your combo box source is the Emp Name and the source for your option group is the status field. In other words, if you choose Emp A and they are active that is what you will see on the form; if you change them to inactive, your table data will change. What you need to pay attention to so it doesn't confuse you is the values for the option group - remember these will be 1 or 2, rather than active or inactive, so that is what you will see in the actual table, but you will read active or inactive on the form. If the table is not prepopulated with the 1 or 2 value, that's okay. You can make the selection from the form which will populate the table with the appropriate data.

I suggest playing with the form and data a little to get used to it. Pick an employee, set their status in the table, then look at your form; change the status on the form and go back and look at the table. Once you see if a couple of times, it'll make sense.

I've got a table and form made here I can send you if you need it. Let me know.

Wendy, could you please send it to my gmail account. My tables are not populating properly.

Thanks
May 15 '06 #5
wlc04
70
I've been playing with this and seem to have some issues. By making the emp name the combo box, it is the value that is being changed rather than the emp status. This is not good, I'm thinking :) However, if you use the navigation buttons to change emp name then you can make the change to the option group and it changes the value in the table. Are you set on using combo boxes for the employee and option group for the status????
May 15 '06 #6
wlc04
70
I'm not seeing that way working. Using the combo box for the emp name list changes that field and not the status field. So if I've got John Inactive, Paul Active, George Inactive and Ringo Active, then if I choose another name from the combo box it replaces the current value I have on the screen. So I could end up with two Ringos and nobody wants that.

I think you need to have the emp status field formatted as a combo box with active/inactive or make the status field a yes/no and then you will have one checkbox or radio button which will show the status. Then if an emp is inactive the button would not be checked.
May 15 '06 #7

Sign in to post your reply or Sign up for a free account.

Similar topics

13
by: mr_burns | last post by:
hi, is it possible to change the contents of a combo box when the contents of another are changed. for example, if i had a combo box called garments containing shirts, trousers and hats, when...
3
by: vgrssrtrs | last post by:
<html> <head> <script language="JavaScript"> <!-- /* *** Multiple dynamic combo boxes *** by Mirko Elviro, 9 Mar 2005 *** ***Please do not remove this comment
5
by: Harry Haller | last post by:
<select name="cboPlaces" id="cboPlaces"> <option value="3">Countryside</option> <option value="4">Forest</option> <option value="5">Mountain</option> <option value="6">Desert</option> <option...
1
by: Alex | last post by:
Acc97. I have a form which within a subform records machine down time. I have a total of 8 machines. (1-2-3 ect.) What I have been doing is using a combo box linked to the record table to...
2
by: Steve | last post by:
Access 97. I have a form where there is an option group with two buttons, and a combo box. The combo box Row Source is a query. The option group has two options a) include a subset of the...
2
by: kiranmn75 | last post by:
I want to dynamically populate a combo box through javascript. Data is coming from a array. Sometimes data list may contain items in excess of 2000. Explorer takes more than 5 seconds to...
1
by: The Eclectic Electric | last post by:
I'd be very grateful if anyone could help me with this. From my limited knowledge of Javascript I don't think it is possible, but I'll punt anyway. I downloaded and very slightly adapted this...
5
by: consonanza | last post by:
I am working on a report filter form. It has 2 combo boxes (cmboSelectSubject and cmboSelectCategory) to select criteria. Selecting an entry in combo 1 restricts the options available in combo 2....
8
beacon
by: beacon | last post by:
Hi, I am creating a relatively simple database, but I've come across something that I haven't been able to find an answer for. I typically research until I'm blue in the face, so my frustration...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.