Writing a frontend in VB6, need help with reports

[ELaJaunie]

I hope this is the right place to post this.

I'm using VB6 to write a front-end for an Access database that has nothing but a single table in it. I've successfully linked to the DB and am able to view records, create new records, delete records, etc. But I've come upon a bit of a snag. I'm using a data environment to process the reports I want. One of the reports is a big spreadsheet with all the information on the table. The second is supposed to be a one-page report containing the information on the currently displayed record. I dug around in other places and I found that I had to make a command that groups the data environment against an autonumber. Well, I did that. But when I try to display the current record, no matter which one I'm looking at, I always get record 1. I've got like 88 records in this thing and I want to be able to view any one at any given time. I'm using the data reports in VB to actually write my reports. I'm using an ADO control for my main form. I had done this before in Access by building my report against a query, but I can't for the life of me figure out how to use queries in VB6.

Please help me out here. I really need to get this working. If this isn't the place for me to post this question, please point me in the right direction.

Thanks in advance!

 

[Pat Hartman]

Just because you are storing your data in Access doesn't make this an Access question. You are going to have to use a query that selects only the record you want to report on. You are more likely to get help with that in a VB column.

 

[ELaJaunie]

I just thought that maybe someone had done something similar. I'm only trying to get an answer from every possible source.

 

[Pat Hartman]

Sorry, I wasn't suggesting that you shouldn't post here just that you might get a better answer faster, elsewhere.

 

[ghudson]

You might have better luck getting an answer to your question in the Visual Basic section at the Utter Access forum.