number in to different text boxes in a report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an employee database file. A record like a passport no (eg: 12345)
should print in different boxes in a report. This is for some form templates.
I had made a report according to the template given by some departments. In
their form passport number is to be typed in different boxes. Since my
passport no. record is singled field, how can I print it in different boxes
thru a report.

Thank your very much for your early response.

Regards,

Aja Mery Abraham
Saudi Arabia
 
On the on print section of the report where the text boxes of the passport
are, you can write the code

if condition then
me.passport1.ControlSource = "PassportNameFromTable"
else
if condition then
me.passport2.ControlSource = "PassportNameFromTable"
else
me.passport3.ControlSource = "PassportNameFromTable"
end if
end if

if you have several fields of passport just change the ControlSource to fit
your requirement
 
Back
Top