FindFirst - What am I doing wrong? (1 Viewer)

[AndyWilcock]

Set rstGroups = dbs.OpenRecordset(Name:="Group_T", Type:=RecordsetTypeEnum.dbOpenDynaset)

MsgBox Me.Group ' This shows 340 on the screen which is the group i want from rstGroups
rstGroups.FindFirst "GrpID = Me.Group" ' But this line finds the first group in the rstGroups table - grrrrr

so why......

MsgBox Me.Group ' This shows 340 on the screen which is the right Record i want from rstGroups
rstGroups.FindFirst "GrpID = 340" ' finds the correct Record

What am I doing wrong?

 

[theDBguy]

Hi. Welcome to AWF!

Try:

rstGroups.FindFirst "GrpID=" & Me.Group

Hope that helps...

 

[Gasman]

"GrpID = " & Me.Group

 

[AndyWilcock]

Hi. Welcome to AWF!

Try:

rstGroups.FindFirst "GrpID=" & Me.Group

Hope that helps...

Ah yes - thank you for your welcome and answer!! thank makes so much sense now!!

 

[theDBguy]

Ah yes - thank you for your welcome and answer!! thank makes so much sense now!!

Hi. You're welcome. @Gasman and I were happy to assist. Good luck with your project.