Populating fields automatically based on corresponding filed entry

[Fozi]

Can one of you genius' please help me out. I have a form with a combo box in which I choose an option. Upon choosing this option I would like a corressponding field on the form to automatically populate within the user having to enter the data.

I've attached a mock up of what I'm referring to. Any help would be much appreicated. Thanks.

 

[dkinley]

I normalized the database a wee bit and auto updated the second field on the form.

-dK

 

[Fozi]

Thanks but attachment is downloading as read only so i can't make amendments/additions

 

[Fozi]

Thanks I got it going.

Can you mind tell me what you changed. I'm looking to replicate it on my master system


Thanks for everything. Really appreciate it. Easy when you know how I guess!

 

[dkinley]

I did the following to normalize the db a little more. This prevents the repeated storing of the same text and only stores the indexed ID.

- Added an autonumbering primary key to TBL_Projects.
- Removed the field in Projects that had the text for the indicator.
- Added a field to TBL_Projects as a foreign key for TBL_Indicators_Lookup.
- Changed the combo box to store only the ID number from Indicators into the foreign key in projects.


I did the following to update the form and display correctly.

- Changed the formatting of the combo box to only display the the text from table indicators.
- Changed the combo box to expand it's column count.
- Added an After Update event on the combo box to automatically update the type field on the form.

-dK

 

[Fozi]

Tremendous.

Thanks for all your help. Very much appreicated!

 

[dkinley]

You bet.

-dK