Form doesn't show

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I had a form which was based on a query. I added a tab control to the form
and added a couple of tables that I want add to the second page of the tabbed
control as subforms. I changed my query to include the other tables. Now when
I go to open the form the form is blank. If I go into the design view of the
form everything is there but in form view it's just a blank form. Can I not
add other tables to a query and add it to a form.

I have been working on this form for hours and thought I had everything
right and now the form is blank. Can anyone help. I am using Access 2003.

Thanks in advance.

Best regards,

Dee
 
Run the query without the form, can you add records or update the records?

Sometimes after adding a link to another table the query become
unupdatetable so you can't add or update the records returned, and if the
form DataEntry Property set to yes, or if the query return no records the
form will come up blank without showing the fields.

fix the query first that you can update it, if necessary use less tables,
and use sub forms to retrive the related data from this tables.
 
Back
Top