Increment number based on combo box selection.

[foxtet]

Hello

Please find the attached picture of the form.
I want to print token number for the selected doctor in doctor's combo box when you clicked to command button Issue Token. The printed token in the form can be saved in the table'd record source table

Doc A token 1
Doc B token 1
Doc C token 2 etc..

any help

fox

 

[missinglinq]

...I want to print token number for the selected doctor in doctor's combo box when you clicked to command button Issue Token.

Where is this Token Number coming from? Is it a Column/Field in the Doctor Combobox? Is it stored in a separate Table, along with the Doctor's name?

BTW, if you're always going to want a Token Number issued, you can use the AfterUpdate event of the Combobox to do so automatically, without clicking a button.

Linq ;0)>

 

[foxtet]

Thank you for the reply

I found solution for that, but the problem is that when i print Service memo slip the doctor's number appears on it. but I want doctor's name to be printed on it...any help...

pls refer the attached file

fox

 

[missinglinq]

...the problem is that when i print Service memo slip the doctor's number appears on it. but I want doctor's name to be printed on it

Then you need to tell it to print the name rather than the number. Once again the question is where does the information come from? You never answered this question.

I don't run version 2007/2010 so cannot open your attached file.

If the doctor's name and number both come from the Doctor Combobox, the number field is probably the bound field. The textbox on the report is probably something like

= Me.DoctorCombobox.Value

or simply

= Me.DoctorCombobox

since Value is the Default and doesn't have to be used.

The assignment probably should be something like

= Me.DoctorCombobox.Column(X)

where X is the Column Index for the field holding the doctor's name.

Linq ;0)>