Continous Form with Combo Boxes

[dhogan444]

I am trying to display a text ticket status in a combo on a continuous form. The control source for the combo box is the TicketStat field of table “tblTicketStatus”. The values in the TicketStat field are the primary keys for the option ticket status table. (Example: The control source display 1 or 2, where 1 is the ID for “Open” and 2 is the ID for closed”). The record source runs a query that pulls the TicketStat field values (text) from the option ticket status table.



Can you take a look at the attached database and help me figure out the problem?

[DJDJDJDJ]

Hi,

I think I am missing your question here. What exactly is it that you want to do that is not being done here? I looked at your sample DB and it does show the ticket status as open or closed.

[dhogan444]

Hi,

I think I am missing your question here. What exactly is it that you want to do that is not being done here? I looked at your sample DB and it does show the ticket status as open or closed.

Try changing closed to open, then it changes the value to the actual ID for all the records with Open/Closed and does not actually change the individual record value.

[DJDJDJDJ]

Your query for the form data source is selecting the Ticket status from the wrong table. you are selecting

TicketStat_optTicketStat: TicketStat

From optTicketStat

you should change it to select from tblTicketStatus.

After that it was working fine.