470,604 Members | 2,056 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,604 developers. It's quick & easy.

Multi-table form

I'm new to Access...trying to create one form from 5 tables using Access 2002's form wizard. The form has 68 controls and will input info to the correct tables but it won't display records after they've been input. It seems to read only the first record.

I tried creating the form from a multi-table query and got the same result.

Any ideas out there???????

Thanks

--
Atr
Nov 12 '05 #1
2 1638
Do you have the relations between the tables properly defined ?
Bas Hartkamp.
"ariley" <ar****@comcast.net> schreef in bericht news:1z7bc.158119$_w.1772200@attbi_s53...
I'm new to Access...trying to create one form from 5 tables using Access 2002's form wizard. The form has 68 controls and will input info to the correct tables but it won't display records after they've been input. It seems to read only the first record.

I tried creating the form from a multi-table query and got the same result.

Any ideas out there???????

Thanks

--
Atr
Nov 12 '05 #2
I think so...I used the wizard to create the tables, and allowed it to do most of the work. There are 5 tables; 4 are in one to one relationships with the main table. Those four also have various small tables... ex: the main table is address info and it has a small table being used as a pull down for the 'States.
"HS Hartkamp" <hs*********@hccnet.nl> wrote in message news:40***********************@news.wanadoo.nl...
Do you have the relations between the tables properly defined ?
Bas Hartkamp.
"ariley" <ar****@comcast.net> schreef in bericht news:1z7bc.158119$_w.1772200@attbi_s53...
I'm new to Access...trying to create one form from 5 tables using Access 2002's form wizard. The form has 68 controls and will input info to the correct tables but it won't display records after they've been input. It seems to read only the first record.

I tried creating the form from a multi-table query and got the same result.

Any ideas out there???????

Thanks

--
Atr
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

37 posts views Thread by ajikoe | last post: by
4 posts views Thread by Frank Jona | last post: by
2 posts views Thread by Aussie Rules | last post: by
14 posts views Thread by =?ISO-8859-1?Q?Tom=E1s_=D3_h=C9ilidhe?= | last post: by
4 posts views Thread by =?Utf-8?B?SGVucmlrIFNjaG1pZA==?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.