Hi,
I have a really strange problem that I have never encountered in access before.
I am using access 2007 and have a main form with a subform datasheet.
The main form is a stock request and the subform lists items that are requested as stock as part of the main request.
I have add edit and delete buttons on the main form which are working fine. When you press add a add new stock item request form appears (without closing orginal stock request form). When you save the item it closes and updates the subtable in the main form.
Everything works fine and I can add, edit and delete added items from a stock request.
The strange thing is that when I select an item in the subform (which lists the stock request items for the main form) I can no longer edit data on the main form. For examply there is a drop down box listing suppliers on the main form, I can click on it to drop down but cant actually select a supplier. Its like fields for the whole main form become locked.
It is fine when the main form first loads but as soon as I click in the subform, even if there are no records I cant edit anything on the main form. It is like it keeps the focus or something. However I can click on items on the main form, buttons etc work. I just cant edit fields.
This is driving me nuts and been reading different articles on the web to no avail - unless I am not understanding them.
Any pointers are sincerely appreciated with this. Many thanks in advance for your kind assistance.
Rgds,
Bal
I have a really strange problem that I have never encountered in access before.
I am using access 2007 and have a main form with a subform datasheet.
The main form is a stock request and the subform lists items that are requested as stock as part of the main request.
I have add edit and delete buttons on the main form which are working fine. When you press add a add new stock item request form appears (without closing orginal stock request form). When you save the item it closes and updates the subtable in the main form.
Everything works fine and I can add, edit and delete added items from a stock request.
The strange thing is that when I select an item in the subform (which lists the stock request items for the main form) I can no longer edit data on the main form. For examply there is a drop down box listing suppliers on the main form, I can click on it to drop down but cant actually select a supplier. Its like fields for the whole main form become locked.
It is fine when the main form first loads but as soon as I click in the subform, even if there are no records I cant edit anything on the main form. It is like it keeps the focus or something. However I can click on items on the main form, buttons etc work. I just cant edit fields.
This is driving me nuts and been reading different articles on the web to no avail - unless I am not understanding them.

Any pointers are sincerely appreciated with this. Many thanks in advance for your kind assistance.
Rgds,
Bal