Hi,

I had this problem before but was resolved with help from a Member. I'm tryong to rin a macro whihc jumps to a new form with matching field. Problem is the source form is based on query, so Access is giving error for incorrect use of Brackets. I tried to rearrange but it didn't work. I used the following code:

[Judgment_Details]![Case_No]=[Forms]![Main Screen]![Case_Action.Case_No]

Some it does not like Case_Action.Case_No bracket settings. It works fine with Case Action form i.e.

[Judgment_Details]![Case_No]=[Forms]![Case_Action]![Case_No]

Hi http://www.access-programmers.co.uk/ubb/smile.gif

What if u do like :

[Judgment_Details]![Case_No]=[Forms]![Main Screen]![Case_No]

Please let me know what response u get from this.

Cheers!
Aqif

Hi,

Sorry I was off yesterday!!

Thanks it did work, I tried that but I think brackets setting was not right!

Well it's working fine now!!

Cheers!!!