Form Not Working

[GarageFlower]

Hi

I have a database which has three tables in it

I then have put them into a form for datainputtig

however after creating the form it wont let me enter into any of the fields

please can you take a look and tell me what im doing wrong or why it is not working

Many Thanks

 

[Mile-O]

You are using a non-editable recordset as the ControlSource for your form.

The reason it's not editable is that you have just joined a bunch of fields.

Your tables are not normalised. There are instances where your data is not even atomic.

 

[Mile-O]

Also, I can't event tell what is supposed to be happening within this database: fields and tables are not named well and, because of the JOIN specified in the query there will not be any records found until there are values in both sides of the tables. As it stands there are too many blank fields which there shouldn't be.

If you can explain the purpose of this database and what it is supposed to do I'm sure we can suggest a new strcuture for you that works.