OpenForm Question

[calvinle]

Hi,

I am wondering why the use of DoCmd with Where condition does not work, unless I add Datamod to it, then it will work?

If I use the code below to open a form from a subform, it will not take me to the student id as per sWhereClause:

   sWhereClause = "[student_id] = """ & Me.student_id & """"
  DoCmd.OpenForm "frmStudent", , , sWhereClause, , acWindowNormal

If I use the code below, it does take me to the student id as per sWhereClause:

   sWhereClause = "[student_id] = """ & Me.student_id & """"
  DoCmd.OpenForm "frmStudent", , , sWhereClause, acFormReadOnly, acWindowNormal

Anyone know why?

Thanks

 

[JHB]

If [student_id] is a number field type, then you only need one ".

   sWhereClause = "[student_id] = " & Me.student_id

 

[calvinle]

No its not a number field but text field. Mix number and letter.

 

[sneuberg]

I'm curious. What happens if you change acFormReadOnly to acFormEdit, acFormAdd or acFormPropertySettings?

 

[calvinle]

I'm curious. What happens if you change acFormReadOnly to acFormEdit, acFormAdd or acFormPropertySettings?

acFormEdit will take to the record. Not Add for sure, not Property either..

 

[sneuberg]

acFormEdit will take to the record.

Doesn't that solve your problem? What else would you want to do?

 

[calvinle]

Oh no, I was just wondering why with ac will take me to record and without doesnt..

More a learning than a solving problem in my question.