field value auto entered

[koncreat]

I have a main entry form for users to enter daily data into. Two of the fields in the form are part name and cycle time. Those two fields are drop down boxes that get there LOV from a table labeled part names. What i need to happen is when a user selects a part from the part name LOV the corresponding cycle time is automatically selected for them and shows in the cycle time field. The table part names contains both the part name and the cycle time for each part.

 

[Uncle Gizmo]

Have a look at Video 1 on this page on my website:-

https://sites.google.com/site/msaccess457966vmfjg/form-controls/combo-boxes/combo-box-videos

 

[koncreat]

That was exactly what I needed. Thanks for the help!!

 

[koncreat]

Now that I got the box working, how do I get the value that the cycle time box shows into the table?

 

[Uncle Gizmo]

Now that I got the box working, how do I get the value that the cycle time box shows into the table?

Is it necessary?

You can always get it from the Part table...

 

[koncreat]

I will work on some reports they are requesting to ensure it isn't and reply to this post. Thanks again for your help.