Combo Box and Option Group Values

[Desstro]

Attached is an image for better understanding of my question.

As you will see by the form I have two combo boxes and two option groups.

Looking at the query, you'll notice that for package numbers 1 and 2 the program and facility area is what I want it to look like. For package number 3 on the query it is returning the value of CIP and FS1.



I am also having the same problem with my option groups....notice on the query that package number 1 is returning a value of "2" for shift and on the form, "nightshift" is selected.

My obvious question is how to return the nomenclature for the values on the form to my query?

[RuralGuy]

You're not using "Lookup Fields" are you?

[Desstro]

I am for the combo boxes but not for the option groups.

I hope your not getting ready to tell me it's not possible.

[RuralGuy]

Now that your ComboBoxes are defined on your form, remove the Lookup Fields in the table: http://www.btabdevelopment.com/ts/removelookups

[Desstro]

All lookup fields are already set to text. Still returning the lookup auto number value though. in the lookup tables I have the autoID # set as PKeys....does this make a difference. I guess Ill try it w/o pkeys and see.

[Desstro]

Just as I thought the Pkeys did not make a difference. Still need help please.

[Desstro]

the data I enter on this form gets stored in a table called PkgsReceivedandScheduledStatus. The combo boxes on this form get their data from lookup tables called FacAreaLookup and ProgramLookup. All tables have the lookup set to textbox. is there something i need to do within the property sheet data tab on the form?

See image.

[RuralGuy]

Change the BoundColumn property to 2.

[Desstro]

BOOM! Thanks again. You are the man! I can't believe I didn't think of that though.

Now how can i get my option groups to do the same thing?

I'll keep tinkering and let you know if I figure it out on my own.