I have a database for my company's printers. On the Main menu is a button that opens the CartridgeUse form. On this form is a combo box that allows me to pick a specific printer, which populates various fields about that printer and I then enter the number pages printed, click save and it closes the form. The Main menu also has buttons for each printer. Clicking one of these buttons opens the PrinterData form and shows information (purchase date, repairs, ...) about that printer. On this PrinterData form is a "New Cartridge" button that opens the same CartridgeUse form. When I go to the CartriadgeUse form from the PrinterData form, I want it to automatically pick that printer form the Combo box, which then would populate the various fields.
I've tried a few things like this without success
Private Sub Form_Load()
If Forms!PrinterData!Text12 = 1 Then
Forms!CartridgeUse!Combo76.Column(0) = 1
end if
Can someone steer me in the right direction?
Thanks
I've tried a few things like this without success
Private Sub Form_Load()
If Forms!PrinterData!Text12 = 1 Then
Forms!CartridgeUse!Combo76.Column(0) = 1
end if
Can someone steer me in the right direction?
Thanks