Feb 12 2007, 04:50 AM
Is there a way to create a data input form which starts with one line of fileds for data input, but when you start to enter data in those fields it creates another line of fields underneath so as to be able to enter another record?
I know the obvious way it to have a subform in table mode which will allow the addition of data and each time give you another empty line of fields to fill in, but i would like to do this in a form.
Hope this makes sense.
Feb 12 2007, 04:54 AM
Use a continuous form
Feb 12 2007, 05:50 AM
How would this work? I have two fields which need to be given [TagNumber and CustomerCode]. At present i am running the complete thing in VBA using Input boxes asking for Tag Number and Customer code. When a Valid Tag number and Customer Code is entered then the TagDetails Table is updated with the relevant information - Date Requested, Customer Code, Bin Number, Tag Number.
How do i convert this into a continuous form so that the user still only enters the two items of data, but the rest of the information is added like the coded version does?
Feb 13 2007, 04:05 AM
How do i create continuous forms when there is no table that the form is associated to?
Feb 13 2007, 07:07 AM
In the form header you have combo/text boxes for entering a new record. The form detail area is continuous, and displays all records
"no table that the form is associated to"
What happens to the data which is entered, it must be stored somewhere.
The continuous part of the form needs to be based upon a query (or table)
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here