If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Update Form with Command Button
I have a report which is created using criteria entered into a form. There is
already a button on the form which opens the report. If someone does not tab out of a particular box then sometimes the the control isn't updated and the report doesn't get the proper criteria. I can use the button to update all of the individual controls before creating the form, but can I use the button to update the entire form instead? |
#2
|
|||
|
|||
Update Form with Command Button
RMires,
Just do a... Refresh DoCmd.OpenReport... etc... -- hth Al Campagna Microsoft Access MVP 2006-2009 http://home.comcast.net/~cccsolutions/index.html "Find a job that you love... and you'll never work a day in your life." "RMires" wrote in message ... I have a report which is created using criteria entered into a form. There is already a button on the form which opens the report. If someone does not tab out of a particular box then sometimes the the control isn't updated and the report doesn't get the proper criteria. I can use the button to update all of the individual controls before creating the form, but can I use the button to update the entire form instead? |
#3
|
|||
|
|||
Update Form with Command Button
On Sat, 9 Jan 2010 06:41:01 -0800, RMires
wrote: I have a report which is created using criteria entered into a form. There is already a button on the form which opens the report. If someone does not tab out of a particular box then sometimes the the control isn't updated and the report doesn't get the proper criteria. I can use the button to update all of the individual controls before creating the form, but can I use the button to update the entire form instead? The problem isn't that the textbox still has the focus - clicking the button changes the focus, just as tabbing out would. The problem is probably that the record is still on the form but not yet written to the table (to become available for the report). If it's a bound form you can force a write to disk using If Me.Dirty Then Me.Dirty=False in your button code. -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|