input form not working

Posted on 2011-05-03
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
    LVL 12

    Assisted Solution

    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 39

    Accepted Solution

    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

    adding primary key helped your right- now just need to not change records that filled in before
    LVL 39

    Expert Comment

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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
    A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
    As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
    What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

    760 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

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now