Can't select item from combo box

[Gavx]

So I have this form with a combo box which successfully displays a range of items from which I would like to select from - but unfortunately I cannot. I cannot select anything from the combo box.

I have checked the form and table to ensure I have edit rights - which I do.

The form is based on a query - attached is a picture of the relationships within the query.

I assume I have created a non updateable query but this is only an assumption.

I am lost about the best course of action to take.
Is there a way to identify the problem?

Do I just cut my loses and recreate the functionality somehow?

Thanks for any help.

 

[JHB]

...
Is there a way to identify the problem?
...

Open the query without the form, can you now add a new record?
If not, then below is a link to "Why is my query read-only?"
http://allenbrowne.com/ser-61.html

 

[Gavx]

Thanks for that.
The disapointing news is I cannot amend the query records.

I went to the site you mentioned and saw;
"It uses JOINs of different directions on multiple tables in the FROM clause. Remove some tables."

What are joins or different directions?

I should mention that the FROM statement reads;

FROM (ProductType INNER JOIN Product ON ProductType.ProductTypeID = Product.ProductTypeID) INNER JOIN (Customer INNER JOIN ((Booking INNER JOIN (AirplaneTransport RIGHT JOIN BookingProduct ON AirplaneTransport.ID = BookingProduct.PlaneDetails) ON Booking.BookingID = BookingProduct.BookingID) INNER JOIN Guest ON (Guest.GuestID = BookingProduct.GuestID) AND (Booking.BookingID = Guest.BookingID)) ON Customer.CustomerID = Booking.CustomerID) ON Product.ProductID = BookingProduct.ProductID
ORDER BY BookingProduct.BookingID, ProductType.ProductTypeID;

 

[pr2-eugin]

The three types of JOINS supported by Access are LEFT, RIGHT and INNER. Sometimes (very rarely) all three JOINS could come into action. Which means there is something wrong with your Table structure. Or too many tables on the JOINS, so try and remove a few tables.

 

[Gavx]

I have identified that if a remove a particular table in the query it becomes editable. However that field provides a purpose.

I am thinking that I could remove the table but replace the information on the form with a text box and DLookup formula.

Is that a sound approach?

 

[pr2-eugin]

It is a good option, provided you do not over use DLookup, they are normally nasty little things. Used sparingly they work wonders. Good luck !