|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
|
Hello All,
This is my first post here and I'm hoping I can find a good answer to this seemingly tricky problem: I think this might be very simple but I just don't know. I have a form that is capturing the data for a Purchase Order. After issuing the command Add New Record the user enters all the data. I also have a button that allows them to print the new created PO. If I leave the form and come back and want to print the PO, everything works fine. But while the new entrered information is still on the screen, one can't print the PO. Reason being, that the information hasn't been saved yet. I need a command that will force the current record to flush and save to the table before I print and I need to this programatically. Something equivalent to Me.update, but since I am not using code to do all this, I don't know what command to use. Anyone has an idea? Thanks in advance. |
|
#2
|
|||
|
|||
|
I found it, if someone else needs it here it is.
I thought it must be something real simple and it was. Me.Refresh This will force all your current's Form info into the database. |
![]() |
| Viewing: Dev Articles Community Forums > Databases > Microsoft SQL Server > How to save the current record in a form programatically |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|