Field do not appear on form

M

Mike Busch

I am trying to creat a form from several tables. There are many fields in the
form, if I select all the fileds in the wizard, and then finish, just the
form outline appears with no fields in it. I remember have this problem
before, I can't get out of it. Any ideas.
 
R

ruralguy via AccessMonster.com

You are describing a form bound to a RecordSource that has no records
returning.
 
R

ruralguy via AccessMonster.com

Go to the Data tab of the properties sheet for the form and set DataEntry to
Yes while you get the first records in. Make sure Allow Edits and Allow
Additions is set to Yes. You can turn DataEntry off after you get a record
in. You may still have a NonUpdateable query, which is another problem.

Mike said:
Yes. I was going to use the form to input data records
You are describing a form bound to a RecordSource that has no records
returning.
Click to expand...
[quoted text clipped - 3 lines]
Click to expand...
 
M

Mike Busch

Tried that, I think it might be the relationships.
I have a field in the tlbRenter called (becuase it is a unique number) SS#.
All the other fields (in other tables) are related to this by this one to
many. All the other fields are called renternum. Only two fields are related
differently, Unit and keys are related at one to many via an apartment number
(aptnum).

I realize this is the most important part of a DB, do you know anyplace I
can go to (on the web) the work on relationships.

ruralguy via AccessMonster.com said:
Go to the Data tab of the properties sheet for the form and set DataEntry to
Yes while you get the first records in. Make sure Allow Edits and Allow
Additions is set to Yes. You can turn DataEntry off after you get a record
in. You may still have a NonUpdateable query, which is another problem.

Mike said:
Yes. I was going to use the form to input data records
You are describing a form bound to a RecordSource that has no records
returning.
Click to expand...
[quoted text clipped - 3 lines]
form outline appears with no fields in it. I remember have this problem
before, I can't get out of it. Any ideas.
Click to expand...
Click to expand...
Click to expand...
 
R

ruralguy via AccessMonster.com

There are many. Here's one: http://r937.com/relational.html

Mike said:
Tried that, I think it might be the relationships.
I have a field in the tlbRenter called (becuase it is a unique number) SS#.
All the other fields (in other tables) are related to this by this one to
many. All the other fields are called renternum. Only two fields are related
differently, Unit and keys are related at one to many via an apartment number
(aptnum).

I realize this is the most important part of a DB, do you know anyplace I
can go to (on the web) the work on relationships.
Go to the Data tab of the properties sheet for the form and set DataEntry to
Yes while you get the first records in. Make sure Allow Edits and Allow
Click to expand...
[quoted text clipped - 8 lines]
Click to expand...
 
Top