Forms based on multiple tables

[Diplomat]

I used the form wizard to make a form with data from four different tables. I think I&nbsp;&nbsp;followed all instructions correctly, but when I tried to view the form only the header section showed; the detail area was blank. If I look at the form in design view, everything is there, or so it seems.<br><br>The help files are of no help in this problem.<br><br>I appreciate any suggestion.<br><br><font color=red>P.S. by the way, do I always need to use the wizard to make forms based on multiple tables?</font> (note that I don't want to use subforms)<br>Thanks

 

[xtreme1]

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Sure you can.&nbsp;&nbsp;All you would have to do is, go to your forms properties, and in the &quot;Record Source&quot; put something like this:<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SELECT * FROM Table1, Table2, Table3<br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;You can go pretty much as far as you want with that, juat keep adding commas and table names.&nbsp;&nbsp;(Table1,2,3 is obviously replaced with the names of the tables you're pulling data from) =]&nbsp;&nbsp;Good luck!<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<A HREF="mailto:rbio@excite.com">rbio@excite.com</A>

 

[Diplomat]

Thanks x1; that was very helpful. I re-did my form and it works. However, I still have the problem of &quot;<font color=red>invisibility</font>&quot;!!!. First it was an entire form that would not show in form view, and now it is the header of the new form that I just made; it's in there in the design view, but it doesn't appear in form view. Any hints?<br><br>Thanks

 

[Guest_imported]

Yeah same problem here any hints or tips please let us know<br><A HREF="mailto:chrisdrewery@hotmail.com">chrisdrewery@hotmail.com</A>

 

[3rdRail]

This is one possible solution;&nbsp;&nbsp;&nbsp;<br>Check the properties in both the form and header section.&nbsp;&nbsp;Look for the DISPLAY WHEN property and make sure they are both set to &quot;always&quot;.&nbsp;&nbsp;The 3 possible settings for the DISPLAY WHEN property are &quot;Always&quot;, &quot;Screen only&quot;, and &quot;Print only&quot;