Combine previous field data

[benjaminkmartin]

I think this is really easy to do, I just don't know anything about
coding, so I don't have a clue.

I have a form with 5 fields that looks something like this...

Vehicle Name = A <---Combo box (A or B)
Vehicle ID = 1 <---Autopopulated filed based on letter
chosen. A=1, B=2
Location Name = a <---Combo box (a, b, c, d, e...)
Location Code = .01 <---Autopopulated filed based on letter chosen.
a= .01 b = .02 etc...
Location ID = 1.01 <---Autopoulated based on Vehicle ID + Location
Code

I have the first 4 fields working fine, it's just the last one I'm
having trouble with. How do I autopoulate this text box? I even put
the periods in the location codes so that I don't even have to worry
about that when combining the two fields...

 

[KARL DEWEY]

Don't! Just combine in query when needed but not store the same data
twice.
if a part is change then your second storage will be in error.

 

[benjaminkmartin]

Don't!    Just combine in query when needed but not store the same data
twice.  
if a part is change then your second storage will be in error.

--
KARL DEWEY
Build a little - Test a little








- Show quoted text -

I kind of need to. The whole point of the form, actualy a series of
forms, is to build a unique pin ID number. This is accomplished after
Vehicle ID, Location Code, Component Code, Connection Code, and Pin
number are all inserted. in sequential forms.

Vehicle ID and Location code make 1.01
add component code and get 1.01.001
add connection code and get 1.01.001.J1
add pin number and get 1.01.001.J1.1

Along the was additional information is stored with the codes. At the
compoenent code level a drawing number is stored... so I need to have
that 1.01.001 stored somewhere anyway so the drawing number can be
associated with it in a table.

Could I just cut down the form to 3 fields if I should reduce the
data?
Take my form from above and take out the vehicle ID and location name
fields and just have the location ID populate from the two combo
boxes?

But yet again, I don't have a clue how to actually implement that with
codes...

Thanks for the help

 

[KARL DEWEY]

Data is stored in table fields, not forms. Forms are for data entry and
display.
Use a form with text box for each data element bound to your table fields.
Then you can combine the data elements in a query for display form or report.
Like this ---
Location ID: [Vehicle ID]&"."&[Location Code]

 

[benjaminkmartin]

Data is stored in table fields, not forms. Forms are for data entry and
display.
Use a form with text box for each data element bound to your table fields..  
Then you can combine the data elements in a query for display form or report.
Like this ---
    Location ID:  [Vehicle ID]&"."&[Location Code]

--
KARL DEWEY
Build a little - Test a little

I kind of need to.  The whole point of the form, actualy a series of
forms, is to build a unique pin ID number.  This is accomplished after
Vehicle ID, Location Code, Component Code, Connection Code, and Pin
number are all inserted. in sequential forms.

Vehicle ID and Location code make 1.01
add component code and get 1.01.001
add connection code and get 1.01.001.J1
add pin number and get 1.01.001.J1.1

Along the was additional information is stored with the codes.  At the
compoenent code level a drawing number is stored...  so I need to have
that 1.01.001 stored somewhere anyway so the drawing number can be
associated with it in a table.

Could I just cut down the form to 3 fields if I should reduce the
data?
Take my form from above and take out the vehicle ID and location name
fields and just have the location ID populate from the two combo
boxes?

But yet again, I don't have a clue how to actually implement that with
codes...

Thanks for the help- Hide quoted text -

- Show quoted text -

I didn't do exactly what you suggested... but you definitely got me
thinking on the right track... so I definitely appreciate that.

Thanks for the help!