update query

[KnowNothing]

Can a UPDATE query run from a report? I have tried to update the table by using a unbound text box by placing the update query in the Control Source. That doesn't work. I then tried to use a bound text box and placed the update query in the Control Source of that text box. That does not work. So is trying to do a UPDATE from a report impossible?

 

[ByteMyzer]

In principle, a Report is for the purpose of reporting data, not modifying it. What is it that you are attempting to accomplish with an UPDATE query, and why do you feel it needs to be done from a Report?

 

[KnowNothing]

I am trying to create Membership cards. Each membership card has a unique
consecutive number (the starting number iis determined by the user entering it in a unbound text box). What then needs to be done is to update the members information in the table with this now assigned membership number.

I am now able to have a text box "pop-up" that requests the user to enter a starting number for the membership cards. There are different groups of cards and for each group the user enters the starting number. Each group of cards are consecutive.

My only problem now is to "update" the table with the designated card number. This has to be done when the membership card is printed.

The only way I have found to do this is to create a "update" query within the "detail_print" event.

Am I going thought a lot of work where I could do it a easier way?

 

[Kinger43]

If you create a form with an unbound text box where you enter the membership number, or starting number, whatever it is that you are trying to update in the members table and then make a button that, when clicked, runs the update query and makes the report. Then all the user has to do is open the form, enter the number and click the button. The report is made and the update query is run.