Displaying Data from multiple tables

Topic

New Reply

Can someone please help me out with this, I need my case statement corrected as I’m having trouble displaing data from 3 tables. Please Please, this is very urgent.

View Consignment Details

Back to List

Consignment ID
Destination
Origin
Status
Type
Description
Remarks
Depart Date
Arrive Central
Depart Central
Arrive Dest
Sent Off Dest
Sender Name
Sender Business
Sender Address
Sender Work No
Sender Home No
Sender Mobile No
Email
Receiver Name
Receiver Business
Receiver Address
Receiver Work No
Receiver Home No
Receiver Mobile No
Email

Reply | Quote

Replies

Hi Mark,

It’s going to be hard to troubleshoot without a little more detail as to the nature of the problem.

However, I will mention a few things that I noticed.

I have never seen or used a Case statement with a colon ( : ) after the Case keyword. It’s possible that it’s not a problem, but I’ve certainly never seen that before. The common construction is:

Select Case [Variable]
  Case [Value]
    Code Here
  Case [Value] (etc.)
    Code Here
   Case Else (if needed)
    Code Here
End Select

Also, you closed a recordset after setting it to nothing. Try moving the rs.Close line above set rs=Nothing.

Please post back with any further error messages or specific line numbers that are not working.

Good luck!

Reply | Quote