By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,285 Members | 1,619 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,285 IT Pros & Developers. It's quick & easy.

Viewing records in Form View

P: 4
Hi. New to this, but hoping somebody can help me!!!

I have created 4 tables, and a form which links to these tables. I want to be able to view all the records as a form, but can't seem to work out how to do this. The tables are all linked to one another via Relationships.

Please help!!!
Aug 9 '07 #1
Share this Question
Share on Google+
5 Replies


P: 33
Hi. New to this, but hoping somebody can help me!!!

I have created 4 tables, and a form which links to these tables. I want to be able to view all the records as a form, but can't seem to work out how to do this. The tables are all linked to one another via Relationships.

Please help!!!

Hi,

Use the Form wizard to create a form.
Click Form
Select "Create form using Form Wizard"
Follow the promts.

it is as simple as that.




chuz,
Kathy
Aug 9 '07 #2

P: 4
That is how I managed to get the Form to start with. I can enter data into the form and it will flick it off to each table. But when I re-open the Form, none of the data is there (but it is still listed in the Tables).

I want the form to display all the data I have already entered...
Aug 9 '07 #3

P: 4
I will just add that I am using Access 2007... Which appears to be a completely different program to 2003 which I knew like the back of my hand!!!

Thanks
Aug 9 '07 #4

missinglinq
Expert 2.5K+
P: 3,532
In Design View of the form goto Properties - Data. Is the Data Entry property set to "Yes?" If so, set it to "No." Also make sure that AllowAddiions, AllowEdits and AllowDeletions are set to "Yes."

Welcome to TheScripts!

Linq ;0)>
Aug 9 '07 #5

P: 4
Data Entry is set to NO, AllowAdditions, AllowDeletions, AllowEdits and AllowFilters are all set to YES and I still have no luck...

It just shows me a blank form, even though there are plenty of records entered.
Aug 10 '07 #6

Post your reply

Sign in to post your reply or Sign up for a free account.