InfoPath Dev

I changes the formating in the access Db of the ID feild. to get the value correct but it does not transfer to the form. how do you get the formatting to transfer to the form when queried. 

Or could this be set  with the defualt field value of Customer ID  

I want to set the value of my Customer ID on submit  of the form. I would like to use auto ID generated by Access + leading zeros. In excel I could do it like this =RIGHT("0000000000"&B1,6). I am not sure how it would look in InfoPath.  So on submit it should submit 000001 to the database once to 10 it would be 000010 and ...

I figured it out. Trend Micro Internet security does not play nice with infopath. I am going to call them to try to get them get this worked out. Once I turned it off it works great. Thanks  

I Uninstalled office and  reinstalled it.  it workd 3 time when i previewed the form and once when I Published it. Now I am back to the same issue

I signed the form under  Tools > Form Options > Security and Trust. Under Form Template Signature section. I used my cert I created and imported into IE. and still no luck I am still getting the error.

I have issues with my InfoPath forms. I am using InfoPath 2007. I have them connected to a Access Database and no special code in the forms. I  receive the access denied error when trying to open the unpublished form. I can open the form in design mode. Then when I try to preview it. I get the "InfoPath cannot open the ...