Combo Box Not Working

[Learn2010]

I have a combo box that won't allow me to select an item. The box is on a subform. When viewing only the subform, it works. When viewing the subform from the main form, it won't work. Any ideas?

 

[pr2-eugin]

Check if the Subform is Locked in a Main form setup. See if it has edit allowed.

 

[Learn2010]

They both do.

 

[pr2-eugin]

I am confused !

 

[Learn2010]

The form and subform have AllowedEdits set to Yes

 

[pr2-eugin]

Can you upload the DB?

 

[Learn2010]

No. It is patient data.

 

[Learn2010]

Let me add this. It is linked to a SQL Server.

 

[Learn2010]

I don't know if this will help anyone but here is what I found out and was able to fix the problem. In the main form, the Record Locks setting was set to Edited Record. I changed that to No Locks and it worked.

Thanks.