Cannot Input data into some of the fields

[goldmedallist]

Hi,

Just a short introduction. I am rather new to this forum and also a beginner to Access development. I am currently working on developing a database for CRM purposes for an organisation.

I have created a form for ease of viewing and inputting data. However, the problem I am encountering is that some of the fields does not allow me to add new entries. All the data seems to be drawn from the right sources and any changes made to the existing data is reflected in the underlying tables but it just doesnt allow me to add new data for some fields.

I have attached a compressed version of the database and I would very much appreciate if anyone could offer any assistance on this issue.

Go to Forms (tabbed)
Fields where data cannot be inputted :

Relationship Info - Service, Relationship Info
Meeting Info - All fields
Client Info - RelationshipNum

Fields where you can input data
All the rest are working fine

Thank you very much for your help!

 

[andrew93]

Hi

Change the control source for your meetings subform to the Meetings table instead of the SQL statement you currently have.

What are you trying to do with the 'relationships' and 'services'? Can you explain how this is intended to work?

Andrew