|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
|
|||
|
|||
|
I'm trying to write in VBA for a form to print the results on another form. (On click OK on a message)
each time the form prints, it's blank. Currently I am using [ID]=[forms]![NCR3]![ID] to select the record required. ID being the relationship between the two forms. So I have one form with data, and ID selcted by Autonumber and require form two to open containing the same infomation as form one (To Print). Can anyone come up with a VBA solution to be able to do this. Example of were I am up to below DoCmd.OpenForm "Scrap Indent Docket", acNormal, "", "[ID]=[Forms]![NCR Report3]![ID]", , acNormal DoCmd.Close acForm, "NCR Report3" DoCmd.Maximize Beep MsgBox "Place defective Item and NCR Docket on you're relevant quarantine area - OK to continue" _ , vbOKCancel + vbDefaultButton1 + vbInformation, "Deficiency Entered" If Click = (2) Then DoCmd.Close acForm, "Scrap Indent Docket" Else DoCmd.PrintOut acPrintAll, , , acHigh, 1, True DoCmd.OpenForm "NCR Reporting2", acNormal, "", "", , acNormal DoCmd.Close acForm, "Scrap Indent Docket" Thanks Last edited by talcummalcolm : November 6th, 2003 at 08:00 AM. |
![]() |
| Viewing: Dev Shed Forums > Programming Languages - More > Visual Basic Programming > VBA form to form relationship issue |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|