Search results

I think it might be because "lbl" is not sufficient? There are 13 labels to be filled out and they are named lbl, lbl1, lbl2, lbl3, lbl4, lbl5, etc...your code does not address that?

this doesnt work. it gets a error "no current record" also, i changed your code to .movenext...not movefirst

Re: Loop Help I have a record set that is based on a query i ran (strBAV)...now, im trying to take the "Core Attribute Value" field from this query record set and fil out 13 labels with the 13 results from this field. So say the results are "red," "orange," "yellow," etc...those records become...

Loop Help I want to turn this into a loop instead of writing it out 13 times... Can someone help me? rstBrickAttributeValues.MoveFirst strBAV = rstBrickAttributeValues!CoreAttributeSpecificTypeD escription Me.lbl.Caption = strBAV rstBrickAttributeValues.MoveNext strBAV =...

I want to turn this into a loop instead of writing it out 13 times... Can someone help me? rstBrickAttributeValues.MoveFirst strBAV = rstBrickAttributeValues!CoreAttributeSpecificTypeDescription Me.lbl.Caption = strBAV rstBrickAttributeValues.MoveNext strBAV =...

Is there a way to write it so that i don't have to individually define which boxes are visible for each possible case (for each possible selection made in the trigger combo box). I have already defined the relationships in the database so i feel like there should be a way to do this. I just cant...

can you give me an example of this trigger or what it would look like?

I know how to toggle them visible using VBA. But i need it to populate the correct number of fields and make them visible automatically for a very large set of Brick Codes and possible Brick Attributes and Attribute Values. It all needs to be automatic. I don't know if you quite understand what...

My only concern is the appearance. For example, if I chose the Brick Code "Bread (Shelf Stable)" I need 7 combo boxes for the brick attributes and their values whereas for the Brick "Chicken - Prepared/Processed" I need 11 combo boxes for the brick attributes and their values. Is this possible...

the Brick (core) attribute should be the combo box labels and the Brick (core) attribute values should be the options within those newly created combo boxes

create. in resposne to the Selected Brick

I did. None of them solved what i was asking for. I know how to make dependent cascading combo boxes. But i need the result of one to create a varying number of other cascading combo boxes.

You rock! That was it, thank you! What exactly did that change about what my code was saying?

Anyone see the syntax error (missing operator)? Me.cboBrickAttributeValue.RowSource = " SELECT tblBrickAttributeValue.CoreAttributeValueDescription, tblBrickAttributeValue.CoreAttributeValueCode, tblBrickAttributeValue.CoreAttributeSpecificTypeDescription FROM tblBrickAttributeValue " & _...

I am totally new to Visual Basic. I have dependent cascading combo boxes setup. The hierarchy goes: Segment Family Class Brick Now, I need the value in the Brick field to create a varying number of other cascading combo boxes. They are the Brick Attributes. The brick attributes are the labels...