Creating Specific Record Count Based on User Input

S

Senturian

I'm trying to create a form that will take a user input as to the number of
records to create and then on save the form will do the QC to verify the data
but I can't seem to create the required number of fields. I don't want to
give the user the option to run on. This data is going to be used to
populate additional tables so control over data integrity is crucial. Any
suggestions besides holding the users hand? Thanks
 
K

KARL DEWEY

It might help folks to see what you tried.
What was your query/macro/VBA/etc.
What kind of QC does it perform?
How many fields does it create?
 
S

Senturian

Good Idea, The User will have to fill in 6 fields with either numbers or text.
THe QC portion will ensure that 1. All fields are filled in, 2. The data
is in the correct format, 3. no duplicate entries exist. The form will be
run strictly VBA with a Append query on the end result updating a larger DB
with the results. I really appreciate the help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dynamically create subform based on user input 2
Input form at adds a new month with each new record 0
Creating a form to pull up records... 5
Open Specific Record 1
Form Not Populating Consistently! 0
Auto Input Today's Date 3
How to get one field to update based on a selection from a drop do 2
Access 2007 - check for existing record 1

Top