Tab Control Problem

[sseawright]

Ok, I'm new to this forum so forgive me if I'm posting something that has been discussed before.

I'm having a problem with a tab control in a report. What I have is a Control with 4 tabs. Only 1 of these tabs will have information entered in it at any given time.

How can I display (on the report) only the tab that has information entered in the fields. Each tab has different fields on it.

For example the fieldnames correspond to the tab and the information being entered (ie. Tab1_Measurement1, Tab1_Measurement2, Tab2_measurement1, Tab2_Measurement2, etc.)

Any help would be appreciated.

Thanks.

 

[KenHigg]

I'm not sure that using tab controls on a report is a good idea to begin with...



Ken

 

[sseawright]

Your probably right.

I'm actually using the tab control on a form but want to be able to print the form using a report.

 

[KenHigg]

Oh, I see. Sorry.

Hum...

Could you build a new query that uses some kind of data off the form/tab control as a parameter(s), then use this as the source for the report?

Ken

 

[sseawright]

Thanks for your help...I figured something out. Did a different method. I designed a new form that was formated how I wanted to print (like the report), added a few if statements to the form_load function, and created a macro to open the form in print preview mode.

My Code:

If Text25 = 0 And Text27 = 0 And Text28 = 0 Then
Right.SetFocus
Left.Visible = False
End If

If Text23 = 0 And Text24 = 0 And Text48 = 0 Then
Middle_from_Left.SetFocus
Right.Visible = False
End If

If Text515 = 0 And Text512 = 0 And Text507 = 0 And Text516 = 0 Then
Middle_from_Right.SetFocus
Middle_from_Left.Visible = False
End If

If Text526 = 0 And Text524 = 0 And Text521 = 0 And Text527 = 0 Then
Application_Number.SetFocus
Middle_from_Right.Visible = False
End If