I have a simple form to record defects on our material both at the beginning of the run and at the end. Let's call them DefectHeadCode and DefectTailCode. Our list of defects is long so I created a separate table for simplicity and maintainability. The Defects table just has the fields DefectCode and DefectDescription. I can't seem to get the Description to be specific on the form for both Head and Tail. I can't add the control to the form for both.

I have been successful at building code behind non-bound controls that does SQL calls for each, but I was wondering if there was anything more elegant using the native workings of Access.

Thank you for your time.

---eric

eric,

I'm not entirely sure I understand how you've set this up - but a thought occurs, are you explicitly stating which table each description is calling from? ie: [table1].[DefectDescription] & [table2].[DefectDescription]

Can you post a snapshot of the form?

"Let's call them DefectHeadCode and DefectTailCode"

To see both you need two fields in your table, one for each.
Or else you use an unbound control for the Headcode and place the starting value into the control using code in the form current event.

I am not exactly sure how to upload things so I took a couple of screen shots. The "-entrylog" file shows the form. This form works because the Head and Tail Cut Defect Descriptions are unbound and I get the values in the background.

I am just wondering if there is a way to use the native functionality of Access to more elegantly and easily bring up the descriptions for both head and tail defects when two fields on the entry log table are pointing to the same external table

Deleted.

This post has been edited by Squire4Hire: Apr 12 2012, 10:01 AM

In your combo boxes, just make sure to include the "DefectDesc" field in the column next to the "DefectCd" field in your rowsource query. You don't have to make the "DefectDesc" column visible in your combo box, but then in the textbox next to the combo box you can reference the DefectDesc column by entering "=cboDefectHead.column(1)" with column(0) being the DefectCd.

Hope this makes sense.

HA!!!

That was perfect. I am learning new cool stuff every day. A much more elegant solution than my "bull in a china shop" sql call.

Thank you so much!

---eric

HA!!!

That was perfect. I am learning new cool stuff every day. A much more elegant solution than my "bull in a china shop" sql call.

Thank you so much!

---eric