I fixed it
Hey,
Thanks for the reply. I found that I had called up lots of tables for the query but only included the one I wanted to. Once I deleted the other tables from the query header it worked perfectly.
Thanks a heap
Tim
Hey guys,
I made a comlicated form from a table. The things is that I now want to base it on a query for security of individual records.
When I change the source in the properties box the form comes up blank in form view. What's going wrong? The fields are from the same table.
Thanks,
Tim
P.S.
P.S. Is there any way to have the default value of the field/value entered automatically change according to the user using, or should I have multiple forms with different hidden ID fields with default values already put in?:confused:
Hey Guys,
I am developing a database for Student Services section. The other staff do not have any training and so I want to make the system foolproof and protect privacy. I know how to make specific objects unavailable (in fact they won't even see the access menu with tables, queries etc...