LinkBack URL
About LinkBacks
Is it possible to add lists in each database form field so that you don't have to type each entry. If so, how?
Thanks in advance.
Is it possible to add lists in each database form field so that you don't have to type each entry. If so, how?
Thanks in advance.
Is the database in excel?, from what lists to which form feilds? over how many rows?, columns? are the form feilds on one sheet? have you a design in progress? can you attach a workbook of what you have and how you want it to look?
just a few questions for you to answer in oredr to expand your chances of getting a solution to your problem!
Not all forums are the same - seek and you shall find
Yes, the database is in Excel. I have a single database with columns of data and I am using data/forms to graphically enter new data sets. The question I have is about each field of entry in the form. Instead of typing each entry I was hoping to be able to create a list which would consist of all previoulsy entered data for each column of data for each entry field.
Of course I would also still want the option of typing in any new data that would not already be part of the list.
See attached spreadsheet.
You can't edit the inbuilt Data Form, you can build your own or use John Walkenbachs form
http://j-walk.com/ss/dataform/index.htm
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
As far as i know you can assign lists to a form, try this create a list on a worksheet, then go to DATA, LIST, CREATE LIST, highlight your list, now on the toolbar that pops up choose the dropdown arrow at the side of the word list and choose Forms, i don't know if the form can be entirely built this way but give ita go!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks