findfirst with multiple columns

[Guest]

I have a table keyed by 3 elements (Schema_Name, Table_Name and
DataElement_Name). I have 3 combo boxes degined to Lookup each of the key
elements (cbo_Schema_Name_L, cbo_Table_Name_L and cbo_DataElement_Name_L).
Each combo box has a Row Source Property set to a query using the appropriate
filter(s). The queries are working fine.

The VBA wizard generated the following FindFirst command:

rs.FindFirst "[DataElement_Name] = '" & Me![cbo_DataElement_Name_L] & "'"

How to I code FindFirst to include all 3 data elements? The syntax of the
FindFirst command is very confusing to me.

Thanks,
-John

 

[Marshall Barton]

I have a table keyed by 3 elements (Schema_Name, Table_Name and
DataElement_Name). I have 3 combo boxes degined to Lookup each of the key
elements (cbo_Schema_Name_L, cbo_Table_Name_L and cbo_DataElement_Name_L).
Each combo box has a Row Source Property set to a query using the appropriate
filter(s). The queries are working fine.

The VBA wizard generated the following FindFirst command:

rs.FindFirst "[DataElement_Name] = '" & Me![cbo_DataElement_Name_L] & "'"

How to I code FindFirst to include all 3 data elements? The syntax of the
FindFirst command is very confusing to me.

If all three of the conditions must be specified then you
can use:

rs.FindFirst "[DataElement_Name] = '" _
& Me![cbo_DataElement_Name_L] & "'" _
& " And Schema_Name = '" & Me.cbo_Schema_Name_L & "' "_
& " And Table_Name = '" & Me.cbo_Table_Name_L & "' "_

 

[Guest]

Marshall,

Wow! Thank you so much.

rs.FindFirst "[DataElement_Name] = '" & Me![cbo_DataElement_Name_L] & "'" _
& " And [Schema_Name] = '" & Me.[cbo_Schema_Name_L] & "' " _
& " And [Table_Name] = '" & Me.[cbo_Table_Name_L] & "' "

Worked great.

Thanks,
-John

I have a table keyed by 3 elements (Schema_Name, Table_Name and
DataElement_Name). I have 3 combo boxes degined to Lookup each of the key
elements (cbo_Schema_Name_L, cbo_Table_Name_L and cbo_DataElement_Name_L).
Each combo box has a Row Source Property set to a query using the appropriate
filter(s). The queries are working fine.

The VBA wizard generated the following FindFirst command:

rs.FindFirst "[DataElement_Name] = '" & Me![cbo_DataElement_Name_L] & "'"

How to I code FindFirst to include all 3 data elements? The syntax of the
FindFirst command is very confusing to me.

If all three of the conditions must be specified then you
can use:

rs.FindFirst "[DataElement_Name] = '" _
& Me![cbo_DataElement_Name_L] & "'" _
& " And Schema_Name = '" & Me.cbo_Schema_Name_L & "' "_
& " And Table_Name = '" & Me.cbo_Table_Name_L & "' "_