Fields in Form

[Matisse]

I have built a db really simple and requires no expertise for anyone to use, just a simple build form. The problem is I cannot type into the fields (which are nominated text or memo) I can type info in the table end but when you call up the form you cannot type directly into there. I have tried all the properties and everything is how it should be, it allows edits etc and is not a read only file. I keep looking at this and now I am stuck!!!! Help this needs to be ready by the end of the day and I don't want to have to rebuild it!!!

 

[ColinEssex]

Firstly - the form is bound to a table or query?

Col

 

[Mile-O]

Firstly - the form is bound to a table or query?

A query.

 

[Matisse]

A query.

It is bound to a query!!

 

[Mile-O]

What sort of joins, if any, are in the query?

 

[ColinEssex]

I'll bet the query has more than one table.

Col

 

[Matisse]

2 tables, join properties option 2.

 

[Mile-O]

Using LEFT (and RIGHT) OUTER JOINs in your queries will result in a non-updatable recordset.

What are the two tables? Can you give an example of their content and structure?

 

[Matisse]

the 2 tables are both text tables (really plain and boring) they are joined by a number (admin number) which links the data on the form, I have no formula's, sums etc infact this is a standard text book stuff (although I am more advanced than this) I take it the problem is essentially with the query?

 

[Matisse]

tables do have a unique numbers but have discovered that there is a fault on VB. Eventually it has boiled down to building a new database which has caused no problems what so ever and works like a dream.

Motto of the story, if it takes you 3 days to try and correct the problem, just build a new one!!!!