Query - table coming into view

[IANGRAND]

It's been a while since i've developed anything in access, and i've found that i have pretty much forgotten all that i knew.

I have created a form with several queries, which update information viewed through a series of textboxes. These queries look up infomration held within the form. On running the queries the information is altred within the textboxes, but the query raises the new updated table for the user to see. They then have to close the table, which is very annoying.

Can anyone suggest a way of running the query without the table jumping up.

Regards

Ian

 

[Pampers]

I have created a form with several queries

Normally you would set one query in the recordsource propert of the form...

Pampers
Keeping it simple can be complicated

 

[TheAceMan1]

How are ya IANGRAND . . .

Hmmm . . . [blue]Post the code for running these queries![/blue]

Somewhere there has to be [blue]a line of code[/blue] opening the table!

See Ya! . . . . . .