Populate one field based on another

[Dazzy]

Hey Guys

I have a complete brain freeze this morning and cant figure this silly thing out lol

See the attached example, I need to populate the Field B on the form from the associated value in SubTable for the data selected in Field A.

Thanks

 

[pr2-eugin]

I have not looked into your DB file, but with your description. I am thinking you are trying to add calculated values to tables is that correct? If so, I would suggest you to have a read through this article : http://allenbrowne.com/casu-14.html

 

[Dazzy]

Hey

No I am not trying to do a calculated field, just display one from another table.

 

[pr2-eugin]

Would Autofill or Cascading ComboBox option work for you?

 

[Dazzy]

Thank you it was autofill I was needing

 

[pr2-eugin]

Glad to help ! Good luck with your project.