If you really mean different fields(not different records), I think you will need to dynamically change the command text of the query.

I don't know how you are going to design the form to let the user choose what information to see, but for this example, I will assume that you have two buttons, one to show the "tuition fees", and one for the "book fees".

I will assume column an table names as well.

Private Sub btnTuition_Click()
 If DataEnvironment1.rsCommand1.State Then
     DataEnvironment1.rsCommand1.Close
 End If
 DataEnvironment1.Commands(1).CommandText = _
 "select tuition_fees as fee from fees_table where ..."  ' put the necessary conditions here
 DataReport1.Show vbModal
 End Sub

Private Sub btnBook_Click()
 ...
 DataEnvironment1.Commands(1).CommandText = _
 "select book_fees as fee from fees_table where ..."  ' put the necessary conditions here
 ...
 DataReport1.Show vbModal
 End Sub

For this example, you should use fee as the DataField property of you rptTextBox (in the DataReport).

If this is not what you needed, please provide more information.

Please complete the following information:

REGISTER / LOG-IN TO DISCUSS

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Submit your e-mail address below to continue

E-mail: 

E-mail: 

Handle:   

Password: 

Forgot Password?

Create Handle: 

Your handle identifies you in ITKnowledgeExchange. Max 30 char.

Create Password: 

Confirm Password: 

Yes, I agree to the IT Knowledge Exchange  Terms and Conditions.

hidden modal window