web enabled form does not open with where clause

[shaunacol]

I have a web enabled Access 2010 database which is hosted on sharepoint. My opening sheet shows all clients and in order to open the specific client details I have a button next to each client. the embedded macro is an OpenForm macro but when I use the where clause below I receive an error. if i take the where clause away then the form opens fine with all the records in it. Any ideas on what is wrong with my where clause


"[ClientID]=" & [ClientID]

 

[shaunacol]

I have tried everything now and am getting desperate. I am currently using the following in my where clause [ClientID]=[Forms]![Frm_ClientDetails]![ClientID]

I am now getting the following error ...the object does not contains the following object ClientID...error 2766

But it does!! Both forms contain ClientID. I have even tried renaming one of the ClientIDs to something else in case it is getting confused. Not idea what to do now.


If I click OK then I receive the following inforamtion but it doesnt help

Frm_ClientDetails, '=ClientID=' + Access.Actions.GetFormItemValue('Forms!Frm_ClientDetails!ClientID',true) + '', Edit, Dialog

Please help I have been at this for hours now. I hate web forms!!!