Result from query, show on form insted of new window ?

S

SpookiePower

I have a button on my form connecting to a query, that when I click it,
show a little form.
In this form I enter a customernumber, and the infos about the customer
shows
in a new window.

I want the result of the search to be viewed in some textboxes on my
main form and
in a subform placed on my main form. I just found out that when I click
the button it
calls this code -

stDocName = "QuerySearchCustomerr"
DoCmd.OpenQuery stDocName, acViewNormal, acEdit

and I found out that acViewNormal, is the new window that the result is
displayed in.
Can I edit this code, so that the result is displayed in the textboxes
and in the subform,
or is I fare away from the answer ?



www.photo.activewebsite.dk
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top