Hi Everyone,
I am having a problem with a web database form. I have a list of contacts and need to show the groups they belong to. Each contact can belong to multiple groups (the one to many relationship). In my form I show the listing of the contact. I would like to add a subform to this to show all the groups they belong to. I tried adding a datasheet, which works fine in development, but when I do the compatibility check, the subform control holding the datasheet kicks up an error. The only way to get rid of the error is to get rid of the datasheet.
When I go to the source control parameter of the subform to select the datasheet, it doesn't show up, but I can manually type it into that field. Only the forms show up. Now, Access shows me that the datasheet is not a web object (there is no globe icon on the datasheet in the shutter bar).
Are datasheets not available for Access Services? If not, how can I work around this? I read that I could by writing some VBA, but Access Services doesn't recognize VBA, only macros.
Any and all help would be aprreciated. I have attached the database in case anyone would like to look at it.
Thank you very much for helping!
Matt