Blank Form

[Guest]

Hi

I have two tables, which I have used in a query, and now I need to make a form. However, when I do, I can only see the form in design view, the form view is completely blank..

Help

 

[John Vinson]

Hi,

I have two tables, which I have used in a query, and now I need to make a form. However, when I do, I can only see the form in design view, the form view is completely blank...

Help

This typically means that a) the query upon which the form is based
has no data in it and b) that it cannot be updated either. Doublecheck
your query: are you joining from the Primary Key (with a unique index)
of the "one" side table to a Foreign Key of the same datatype in the
related table?

You may also want to consider the more standard technique of using a
Form for the "one" side table with a Subform for the "many". You'll
still want to have the Primary Key and Foreign Key, but now you'll use
them as the master and child link field respectively.