Creating Auto Fill after selecting from combo box options.

[maryna]

Hi!

I just learned about Access 2007 since two days ago. I was assigned to do a database on the competency test records for my company.

I currently have 2 tables: tblCompetencyRecord and tblSections.
In tblSections, I have sectionname and sectionhead. PK is the sectionname.

i created a form from tblCompetencyRecord.



i have employee name, employee number, position, section, section head, test period, status and remarks on my form (like wise in my tblCR).

Now, I want to get Section field (combo box) to auto fill the Section Head field. I've searched high n low (i think), but i just couldn't figure it out. I need help.

p/s: please be kind to me. Access 2007 and I know each other only 2days back. thanks!
pp/s: did I mention my boss wants this asap? yes. tanx again.

[pbaldy]

Does this help?

http://www.baldyweb.com/Autofill.htm

[maryna]

hi! i've read it before posted this. its okay . i got it figured out. I made a new one and correct the relationship between the tables and made a form from query. tanx!

[pbaldy]

Glad you got it sorted out.