Choose between two different receiving adresses on a form on print out

[rune75]

Hi
It is possible to make a option to choose between two different recieving addresses before print out of the form. That's meens after I click on the print button on the form I want to choose between address 1 and 2 that the choosen one will be printed on the form. Address one is the default address.



best regards
Rune

[June7]

Certainly possible. The how could probably be any number of ways.

Are you actually printing form? Report is better object for printing.

[rune75]

Unfortunately, it is a form I need to print. The database is build in such way. i hope it is still possible. Someone that can explain how to do it. Thanks

[June7]

Database is not carved in stone. There is no reason couldn't modify to print report.

Regardless, what you want will require code. I use only VBA. Use checkbox Click event
Sub chkUseAlternate_Click
'appropriate code here
End Sub

Options:

1. set visibility of textboxes - can be just two textboxes with concatenated address fields as the ControlSource

Me.tbxAdd1.Visible = Not Me.chkUseAlternate
Me.tbxAdd2.Visible = Me.chkUseAlternate

2. just one textbox and set the ControlSource property with concatenated address string
this is a bit more complicated so won't go into it