Creating a form of multiple tables

[ymiller]

Is there any way that I can create a form using multiple tables and be able to enter data in form view?

I am able to get all the fields onto the form in design view, but for some reason when I switch into Form View, nothing shows up (it's just a blank page).

Please help me!

Thanks!

 

[JeremyNYC]

We're missing some informatin here, but I can't quite figure out what it is.

Did you build a query on which to base this form? What happens when you view the query? If you post the sql of that query (view menu) here we'll be able to help you out a little easier.

Is your form set up in single, continuous, or datasheet?

Do you have the scroll bars enabled in the form's properties? If not, enable them and then scroll around, if possible.

Hmmm.

Jeremy =============
Jeremy Wallace
Designing, Developing, and Deploying Access Databases Since 1995

http://www.AlphaBetCityDataworks.com

Take a look at the Developer's section of the site for some helpful fundamentals.


Remember to reward helpful tips with the stars they deserve.

 

[ymiller]

I did make a query, but when I view the query, all I see are the headings.

Does it matter that I don't have any data entered into the tables?

The form is set up as a single, continuous form.

Thanks for your help!

 

[JeremyNYC]

quick test: put some data in the tables! =============
Jeremy Wallace
Designing, Developing, and Deploying Access Databases Since 1995

http://www.AlphaBetCityDataworks.com

Take a look at the Developer's section of the site for some helpful fundamentals.


Remember to reward helpful tips with the stars they deserve.