|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#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 09: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 |
|
|
|
|