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

Multiple records on form?

P: 51
I have a form that has a place to enter Adjacent Properties, which I only have room for like 6 right now to be entered.. Sometimes their could be 100 entries.

Where you enter that info on the from, kinda looks like a table

I have

AdjacentOwnerName SurfaceAdjacentInterest Mineral AdjacentInterest so on..
__________________________________________________ _______________

Mary Yes no
John no yes

Each one is a text box, I have AdjacentOwnerName, AdjacentOwnerName1,AdjacentOwnerName 2...probably 6 times.. I really don't want to add 100 more so their will be a place to enter all those on this one record, what can I do so they can enter as many as needed and it doesn't take up so much space and it is unlimited???? I tried to make a combo box, but I want each record to go to the correct record (if that makes sense) And with that combo box it only listed 5 of them ,and there 12 records out there. so it doesn't work they way I want..
help please/????? thanks in advance!!
Apr 23 '07 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 10K+
P: 14,534
You need to have your database structured correctly and then enter all multiple values on a subform.

Check out this tutorial.

Normalisation and Table structures
Apr 24 '07 #2

Post your reply

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