Skip to main content

Return to Answer

word wrapped
Source Link
BIBD
BIBD
  • 15.5k
  • 26
  • 89
  • 142

Run this as a check to make sure your fields have the data that you think they have:

DoCmd.RunSQL (" SELECT * FROM tbltesting WHERE" & _
                "WHERE empid= " & Me.txtEmpId.Value & _
                " and testid= " & Me.txtAutoNumber.Value & ";")

Incidentally, you can leave off the .Value portion.

Run this as a check to make sure your fields have the data that you think they have:

DoCmd.RunSQL (" SELECT * FROM tbltesting WHERE empid= " & Me.txtEmpId.Value & " and testid= " & Me.txtAutoNumber.Value & ";")

Incidentally, you can leave off the .Value portion.

Run this as a check to make sure your fields have the data that you think they have:

DoCmd.RunSQL (" SELECT * FROM tbltesting " & _
                "WHERE empid= " & Me.txtEmpId.Value & _
                " and testid= " & Me.txtAutoNumber.Value & ";")

Incidentally, you can leave off the .Value portion.

Source Link
David Walker
David Walker
  • 1.5k
  • 2
  • 16
  • 19

Run this as a check to make sure your fields have the data that you think they have:

DoCmd.RunSQL (" SELECT * FROM tbltesting WHERE empid= " & Me.txtEmpId.Value & " and testid= " & Me.txtAutoNumber.Value & ";")

Incidentally, you can leave off the .Value portion.