New Record
in [General]
|
From: desertbird on 10 May 2010 11:15 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?
From: Dorian on 10 May 2010 11:37 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?
From: Al Campagna on 10 May 2010 11:39 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" <desertbird(a)discussions.microsoft.com> wrote in message news:921FF62C-A778-4E91-A588-8823A258EC72(a)microsoft.com... >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?
From: desertbird on 10 May 2010 11:53 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?
From: desertbird on 10 May 2010 13:55 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" <desertbird(a)discussions.microsoft.com> wrote in message > news:921FF62C-A778-4E91-A588-8823A258EC72(a)microsoft.com... > >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? > > > . >
|
Pages: 1 Prev: date query criteria prompt Next: CAN'T ENTER DATA TO THE DATABASE |