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
|
|||
|
|||
New Record
I have a simple form created on "Transfer#" table that has a Order#, Date,
Total$. My users enter the Order# then press a button that updates the Date and Total$ on the "Transfer#" table and then prints a report of Order from the "Transfer#" table. The Date and Total$ are pulled/queried and updated from another table. The records do not update until my user is on a new record in the form. How can I get the Date and Total$ to update while the user is still on the current record they just entered? |
#2
|
|||
|
|||
New Record
Try:
If Me.dirty then me.dirty = false This should force update of the current record. -- Dorian "Give someone a fish and they eat for a day; teach someone to fish and they eat for a lifetime". "desertbird" wrote: I have a simple form created on "Transfer#" table that has a Order#, Date, Total$. My users enter the Order# then press a button that updates the Date and Total$ on the "Transfer#" table and then prints a report of Order from the "Transfer#" table. The Date and Total$ are pulled/queried and updated from another table. The records do not update until my user is on a new record in the form. How can I get the Date and Total$ to update while the user is still on the current record they just entered? |
#3
|
|||
|
|||
New Record
desertbird,
Do a Refresh in your button code after you've updated the field values. That will force the values to be written to your table, just before the report is opened. Also, I would suggest not using any special chgaracters in your object names... such as Order#, or Total$, and Transfer#. These characters have meaning in Access, and while always "bracketing" might prevent a problem, it's best to avoid them altogether. Also, make Total a bit more meaningful... Try OrderNo or OrderNum... or SalesTotal or CashTotal... or TransferNo... etc... -- hth Al Campagna Microsoft Access MVP 2007-2009 http://home.comcast.net/~cccsolutions/index.html "Find a job that you love... and you'll never work a day in your life." "desertbird" wrote in message ... I have a simple form created on "Transfer#" table that has a Order#, Date, Total$. My users enter the Order# then press a button that updates the Date and Total$ on the "Transfer#" table and then prints a report of Order from the "Transfer#" table. The Date and Total$ are pulled/queried and updated from another table. The records do not update until my user is on a new record in the form. How can I get the Date and Total$ to update while the user is still on the current record they just entered? |
#4
|
|||
|
|||
New Record
Thanks for the reply. Where to I put the If statement? I am a very rusty in
Access. "Dorian" wrote: Try: If Me.dirty then me.dirty = false This should force update of the current record. -- Dorian "Give someone a fish and they eat for a day; teach someone to fish and they eat for a lifetime". "desertbird" wrote: I have a simple form created on "Transfer#" table that has a Order#, Date, Total$. My users enter the Order# then press a button that updates the Date and Total$ on the "Transfer#" table and then prints a report of Order from the "Transfer#" table. The Date and Total$ are pulled/queried and updated from another table. The records do not update until my user is on a new record in the form. How can I get the Date and Total$ to update while the user is still on the current record they just entered? |
#5
|
|||
|
|||
New Record
Thank You for all the tips and suggestions!
"Al Campagna" wrote: desertbird, Do a Refresh in your button code after you've updated the field values. That will force the values to be written to your table, just before the report is opened. Also, I would suggest not using any special chgaracters in your object names... such as Order#, or Total$, and Transfer#. These characters have meaning in Access, and while always "bracketing" might prevent a problem, it's best to avoid them altogether. Also, make Total a bit more meaningful... Try OrderNo or OrderNum... or SalesTotal or CashTotal... or TransferNo... etc... -- hth Al Campagna Microsoft Access MVP 2007-2009 http://home.comcast.net/~cccsolutions/index.html "Find a job that you love... and you'll never work a day in your life." "desertbird" wrote in message ... I have a simple form created on "Transfer#" table that has a Order#, Date, Total$. My users enter the Order# then press a button that updates the Date and Total$ on the "Transfer#" table and then prints a report of Order from the "Transfer#" table. The Date and Total$ are pulled/queried and updated from another table. The records do not update until my user is on a new record in the form. How can I get the Date and Total$ to update while the user is still on the current record they just entered? . |
Thread Tools | |
Display Modes | |
|
|