Arrh..another "blank form" question

[duckster]

I have a few tables linked together by a ClientID autonumber. I'm creating a form now with some fields from each of these tables. After creating the form with the Forms Wizard, I get a blank form (just see the background design), with no field names, or anything.

I've searched on this topic and have tried setting the "allowing additions" to "yes", then later "no", adding some data in the tables, but still nothing.

This problem seems to exist only if I'm adding more than a certain number of tables, as I have no problem viewing the form view when creating a form with a few tables and few fields - -- but when i add more of the tables and more fields, it seems to go blank.

Please help! I've looked at the relationships, and they all look correct.

 

[meboz]

Create the query that underlies the form.

Build it up slowly, checking the datasheet view each time you even add a table to the design grid.

Youll get to the point where the query works, shows data etc, then you add one more table, and it doesnt, and theres your problem.

 

[duckster]

Thanks for the help. The form seemed to show up blank because I did not have any data (for some of the fields) in some of the underlying tables fields. Basically, I have a form that has many fields from 3 underlying tables. Once I added data to the underlying tables, the form view does show the records and fields that was inputted in the underlying tables.

The problem I'm having now is that I cannot ADD more records on the form, AND, I can't edit or change any of the fields already showing on the form. I've searched through forums and can't find a solution. I've tried setting the form properties to "allow additions = yes", and even tried "data entry = yes" as well. Not sure why the form won't let me I can't create a new record or edit the form.

The form has fields from 3 underlying tables:
1)tblClient
2)tblIncome
3)tblRefundDetails

All 3 tables are connected by a ClientID. I've set these relationships already, one-to-many relationship (one client to potentially several income, and several refund details).

On the form, I have included fields from all 3 of these tables. I've included one ClientID field in the form as well (only from the tblClient) to link it all up.

So again, my problem is that I cannot ADD more records on the form, AND, I can't edit or change any of the fields already showing on the form. Help much appreciated.

 

[scschroeder]

The problem is that when you try and add a record, access doesn't know to what table you are attempting to add a record to. I would advise showing your client info on the form and creating two sub-forms, 1 for tblIncome, 1 for tblRefundDetails. This will allow you to enter a new client or new income or new refunddetails. Build your main form off a query of only the data off of the client table. Build 2 other queries, one for tblRefundDetails and one for TblIncome. Link the subforms to the main form via the Client.

 

[duckster]

Thanks a lot scschroeder, appreciated. I learned I had to make two subforms and one main form yest. Not sure how to build a form off a query, so I'm using the wizard (i'm a newbie to access). I have a new problem creating the forms though, thus new thread, still trying to figure out. See thread below:

http://www.access-programmers.co.uk/forums/showthread.php?t=72479