input form not working

Posted on 2011-05-03
Medium Priority
Last Modified: 2012-05-11
hello i have attached db
I have a form- not working right-
when open you will see form come up-
i want to be able to add number to pre number and have it fill each record and if i change number then next records change to new number.
number field can have any number added to it ( now I have made not work at all)-
serial no and code are always already inputed.
thank you
Question by:davetough
  • 2
LVL 12

Assisted Solution

danishani earned 800 total points
ID: 35515022
Do you create a Number based on field SerialNumber, Prenumber, Number and Code?

Try to avoid user the Name Number, while thats is a Reserverd Word in Access.

If you want a customized kind of AutoNumber, look into this threads;

LVL 40

Accepted Solution

als315 earned 1200 total points
ID: 35515099
At first add key to the table tbl1 (SerialNumber). After you will be able to fill Number field.
You can use form header for fields, which should be added to values in you tables and use queries for changing values in tables
May be you can prepare example in Excel of initial values and expected result?

Author Comment

ID: 35515261
adding primary key helped your right- now just need to not change records that filled in before
LVL 40

Expert Comment

ID: 35515339
If you will change data with query, you can add criteria is null for selection only non-filled fields

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
Suggested Courses

807 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question