Form goes blank when I change the source

[tibaxter]

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

 

[Dgavilanes]

First check the query make sure it shows records and the fields on the query matches the one in the form then when you select the query for data source make sure it the correct one.
If that does not work, start with one table in the query and see if that works, add the next and see if that work etc etc. it may be one of those tables that might be causing a problem.
Also check your relationship between each table.
Let me know
Dennis

 

[tibaxter]

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