Auto Populate field based on answer of another field - all in same table

[dragct]

Within my table if Field 1 has an answer of Self (from drop down), then, I would like Fields 6-12 to auto populate; however, if Field 1 does not have an answer of Self, then leave Fields 6-12 blank.

I am not quite sure how to lay this out. I am using Access 2010.

 

[finneyz]

web db or native db

 

[dragct]

I am using a Native db

 

[finneyz]

see this youtube

http://www.youtube.com/watch?v=rSPS24EfijI

 

[dragct]

Thanks...love the video; however, apparently I was not clear on what I am trying to accomplish. Let me try again.

One Table - called Data

Within this table, I have fields:
FirstName
LastName
DOB

Then, I have fields:
Vet? - which is a combo box associated to another table with 6 "choices"
VetFirstName
VetLastName
VetDOB

If Vet? choice is Self, I would like to populate the VetFirstName with what is already in field FirstName, VetLastName with what is in LastName, and so on. If Vet? choice is NOT Self, I want VetFirstName left blank, etc.

Is this type of auto populate an option?

Thanks again for your assistance.
Kim

 

[jdraw]

Please tell us about your tables and relationships.

 

[dragct]

what specifically?

This database is setup with one main table and several secondary tables that are used with Combo boxes.

There are not really any relationships established.

 

[jdraw]

Suppose you were in a line at McDonald's. If you turned to the person behind you and were going to describe your database, what would you tell them?

 

[dragct]

We use this database to track our veteran student certifications for Chapter 33 benefits regarding tuition and fees for the college.

It was established with one main table to house the certification data and numerous queries so that we can pull the data out a number of ways.

We recently had to add the collection of data for vets using Hazelwood benefits as well.

I am attaching a screen shot of the data form...not sure if this will help.



Kim