db seems to be locked

[goju]

any ideas cant enter date now,

when i try windows bleeps at me.

 

[Mile-O]

any ideas cant enter date now,

when i try windows bleeps at me.

Goju, when posting questions can you please post as much information as possible relating to your problem? Include details such as what you have tried, what error messages you get, and - preferably - some sort of evidence that you have tried to remedy the problem on your own whether it be by searching the forum's archives, using Google, or searching the MS Knowledge Base.

It's too hard to know what your problem is when you only create minimal and cryptic posts.

 

[goju]

ok no probs, will do in future.

all i did was add a combo box from a query i made, and now for some reason the changing data in a record is not possible.

the computer beeps at em if i try and change any data.

i cant add a new record , everything seems to be locked.

no record locks are on

confused

 

[goju]

ok its down to the relationships.

but i am very lost

please see attachment.

 

[goju]

ok the error message that im getting

says: The specified field '[Initials]' could refer to more than one table listed in the FROM clause of your sql statement.

confused, because the other tables do not refer to Initials.

 

[Mile-O]

Post the SQL

Change [Initials] in the SQL to [TableName].[Initials], obviously changing TableName to the name of your table.

 

[PARSO]

made a few changes. maybe you should rethink the fields that you had listed in the querys, your relationships may also need changing.
and i could only find the field named "IKGA England Number" on your form not in any tables???