reubenj

I think it was suggested by majestics but you need to check your columnIndex. I am not certain about how MS access handles sql queries, if you could post the layout and contents of your products table I may get a clearer picture.

The javadoc states that only one ResultSet object per Statement object can be open at the same time. Therefore, if the reading of one ResultSet object is interleaved with the reading of another, each must have been generated by different Statement objects. Also you should close the statement object when …

You should probably try adding the CustomPanel instance to the new panel, in your case the instance is myPan. [CODE]myPan = m;[/CODE] Just copies the reference of m to myPan, right now you adding both panels to the frame. [CODE]myPan.add(m);[/CODE] might work Then add myPan to the frame so [CODE]window.add(myPan);[/CODE]