Hi! I have 3 tables called...Customer, Order, OrderID

Customer Table:

CustomerID(PK)
Lastname
firstname
..
..
Etc

OrderTable:

OrderID(PK)
CustomerID(Fk)
DateIn
Equipment
Problem
Receviedby

OrderDetails Table:

DetailID(PK)
OrderID(Fk)
ServicePrformed
TechID
Status.......................My Problem With this one
PartsUsed
DateCompleted

With Customer table I created a form.
Then I make Query called qryOrder to build another form which is a subform for Customers from.

In That query I Included all the fields in Order Table and Staus Field from Order Details.

Status field is a combobox whose row source property is from a query.

I linked the Child and Master Fields for form and subform.

Now the problem here was I am unable to select the value from the status combox on the subform.

Any Help

Thanks
Vad