Option Group Not Populating

[Lowell]

I have an option group that has three options.



I have no defaults. It is an option group for 3 choices of payment.
So I fill in all the information that I need and then the customer shows the type of payment that they plan to use.

I tick the button on the option group that applies.

Then I go to print the invoice.

The type of payment is supposed to be saved in the table with their customer info and is supposed to be printed on the invoice.

The problem is that it doesn't show up at either place until I move to a different record or close and reopen the sale.

Surely there is a way to make it poplulate by tabbing off of it to the print command button??

Or some other way??

[pbaldy]

Sounds like you need to force a save of the record:

If Me.Dirty Then Me.Dirty = False

[Lowell]

where would you recommend putting the code?

On AfterUpdate on each option on in the option group?

Or would you put it on the print command button?

[pbaldy]

I'd put it behind the print button.

[orange]

Is the reporting part of the invoicing process?

You could have some sales/orders/invoicing to update your tables, and then have a separate Reporting Mechanism to print reports from Customers, Orders, ...Invoices, Invoices(PaymentsOutstanding), PaymentsReceived... etc.

But if it is part of the invoice process, then you must ensure the table gets updated with the PaymentType.

Where is PaymentType located?
Can you post a jpg of your tables and relationships?

[Lowell]

In response to your suggestion pbaldy, I guess I don't understand your lingo.

When you say put it behind, what do you mean.
The print command button runs a print macro, not code.
Are you suggesting that I would put the 'save' code before the print command in the macro?

[Lowell]

In response to orange, the payment option is just an option group on the invoicing form.

When I select the customer, the info of what they are buying comes up.
Then I tick the button on the group and it is supposed to print on the invoice what option they chose to print with as mentioned above.
Also, at the end of the day, I can count up the different types of transactions to see if it all equals.

By the way, sorry to not inform earlier, this is an auction sale program, that requires speed at the checkout end of things. I want to make everything as streamlined as possible.

[Lowell]

I have attached these jpgs for your info.

L

[pbaldy]

You should be able to add the macro equivalent to your macro. I think it's in the RunCommand area.