form caption

[Guest]

hi all

I have a form (frmExamSchedule) based on qryExamSchedule. I want to set the
FORM's CAPTION the always be the same as the field txbSchoolName from the
table tblSchoolList.

Is this easy to do?

 

[Guest]

Hi cinnie,

Very simple. In your form's On Current event, have the following code:

me.caption = me.txbSchoolName
me.refresh

(assuming you have txbSchoolName on your form).

Hope this helps.

Damian.