I tried creating a few simple tables to monitor the allocation of equipment to clients. It is returned at the end of two weeks and can then be re-allocated to the next course.
One table identifies the clients, with all personal details. The second identifies the equipment. The third deals with the actual allocation, recording issue and return dates, client name and identification of device. The three tables were connected using the relationships tool.
Everything appears to work until I start inserting data using the form. The first two fields; ClientName and DeviceName, work fine with drop-down menus. When I try to insert the dates in the two remaining fields I get a warning message on the Status Bar, saying  The value cannot be added to this new row until the row has been committed. Commit the row first, and then try adding the value.
I have tried changing the type of relationship link. I ve tried setting up a query and basing the form on that but nothing seems to work. The database is developing nicely and I ve used several queries and forms related to the ClientName without any problem. I can t see what I m doing wrong this time.

---

Reply from Alex Hedley:

Are the combos bound?