Combobox Within a Query

[Psilokan]

I'm not entirely sure if this is possible, however I'm pretty sure I have seen it done in the past. But I've been racking my brains and scouring google for the solution with no luck what-so-ever.

What I'm trying to do is display a query, where one of the fields will have a drop down box that you can select from multiple values. I dont want to give away much information about the database structure (sensitive data, and all that fun stuff I'm sure most of you are familiar with). So I'm going to make up a hypothetical situation here.

Table: Person
Fields: pID, pFName, pLName, sID

Table: Status
Fields: sID, sDescription

Here is the basic query:

Select pID, pFName, pLName, sDescription
FROM Person, Status
WHERE Person.sID = Status.sID;

Then when the query is displayed, I'd like the status description to be capable of dropping down a list of the other possible selections. Now I know this wont work on a standard query. So what I did was create the query, then a form that displays in a query view. I have the one field as a combo box instead of a text box. However I'm just having trouble linking it up, it just shows what the current value is but not the other possible options.

If anyone could point me in the right direction, I would surely appreciate it.

Thanks

 

[Brian1960]

If you have the Form and bind it to tblPerson you can then add the fields to display them. Then for the sID field have a combo box with datasource "Select sID, sDescription from Status" with 2 columns but column width 0cm;2cm and bound by sID (column1)