Setting a Value in a Table based off of Selection in a Comb BOx

[jayo17]

I have access 2003 on Windows XP.

So what i am trying to do is edit a record in a table based off of a specific combo box selection. I know how to make the combo box change the values in a table that it is bound to. Whe i am trying to do is have one of the selections in teh combo box enter a value in a field that it is not bound to.

Specifically, i have employee status (new hire, manager, term, LOA) in a combo box that is linked to an employee info table. In that table i have a "count" field which when LOA (leave of Absence) is seleced in the status box. the count number should be set to "0" since the will not be contributing work. I think it might have something to do with a "select case" code but that is just a guess.

thank s
j

[nico5038]

Looks to me you have a design issue at hand.
Best not to record a count value in your table. Best to have an additional tblStatus table with the Status values and a field "WorkingDay" that holds a 1 or 0.

In a query you can JOIN your table with this table and sum the "WorkingDay" field to get the number of working days.

Getting the idea ?

Nic;o)

[jayo17]

i think i get what you are talking about. But my count isnt going to be a daily count of whether people are working. it is meant to be a reference for a day/month/quarter of how many bodies we have to work. Some people are only considered 1/2 because they might have other duties, while someone might be working full time so we can count them as a full person, or a 1.

does this still warrant another table you think?

i also have another question. i have a text box that is filled by a selection of an item in a combo box, but the text field has a # ID showing up. it is the correct ID but i want it to show the word equivelent.

[nico5038]

Hmm, so the field shouldn't be "connected" with the status :-)
Best to have a separate field to hold the "percentage available", thus 100%, 50%, but also other values can be used.

I get the impression that the connection of the absence status is not really related to the job table. I envision that a person is available for 50% for a certain job. The Absence is recorded in general per date and thus "separate". I would however need more info to judge about that.

For a combobox with two fields you need to make sure it's source holds the two fields (IDand description). Under the Format tab of the properties window make sure that there are 2 columns and that the width is set to 0 (zero).
Thus the first column will be suppressed and only the description will show.

Nic;o)