Button click

[hendrikbez]

I have a button that when I press it it goes to new screen where I can add new data in, and then save it.
I have 10 texboxes in this form, how can I when press the button to add data let it on 3 texboxes show info eg. 4321MAG01- and when I am on the new form I can change or add to it. eg 4321MAG01-123. What vb code can I use

[June7]

What is 4321MAG01? Is this a static prefix? Or is this value dynamic?

[hendrikbez]

4321MAG01- is info that I get from a company, but the number is will always be 4321mag01-000 till 99999 the 000 (depends what number it is) I want to add in, so that I do not have to type the whole number every time. I want 4321MAG01- to show in the textbox when I press the add record(New) button.

[June7]

Options.

1. Input Mask

2. VBA code

3. If the prefix is always the same then it is repetitive data, don't save it. Save the sequential ID into number field and concatenate the prefix in textbox expression when needed.

The sequential part of an alpha/numeric identifier should always have the same number of digits, otherwise records will likely not sort properly: 4321mag01-01119 will sort before 4321mag01-012. Is that what you want?

[hendrikbez]

Thank you, I am new to access, so can you please explain more on what you want me to do.

The 4321MAG01-001 will be for about 5 records and 002 for 1, so it will always change.

So in my textbox I can always type new info and then save it, so in this texbox I want to show 4321MAG01-

[June7]

I don't understand that second statement.

You can input a value (1 - 99999 if you like) into a number field.

Then an expression can be in a query to create a field:

MyID: "4321MAG01-" & Format([fieldname],"00000")

Or in a textbox ControlSource property on a report:

="4321MAG01-" & Format([fieldname], "00000")

[hendrikbez]

Ok I got it to work with Set the default value property for the control(s) to "4321MAG00-"

[June7]

That's one way but doesn't prevent user changing the prefix or even completely deleting it. An Input Mask would.