After Update

[MaleNurse325]

OK ...

I have a database with medicines in stock with storage data.
There is embedded in this form an area for prescribing medicines and printing a medicine label.

On this area there is a field "Patient" which is the name of the guy I'm giving the medication to.

Id like an AfterUpdate to clear the content of the name field so the next patient or user cannot see the name of the person who previously was prescribed the medicine.

Sounds simple to geniuses like you but its bugging the cr*p out of me :banghead:

 

[MaleNurse325]

Actually it is not a drop down but a field on the main form.
The medicines are selected from a drop down box and this the updates the rest of the form with the details of that medicine.
The prescribing details are in a sub section of the same form. It is not a sub form.

The rest of the fields in the sub section of the form are expiry date, batch number, manufacturer and patient instructions for the patient . Stuff like "One capsule to be taken three times a day. Complete the course" This doesn't change (much). The only filed that is updated is [Patient]

After I update the Medicine field to bring up the details of the medicine on the form. All I want to do, after I update the medicines drop down is to delete the contents of the field [Patient]

I hope that's a little clearer

 

[Gasman]

Why not just clear the form after you print the label.?

 

[MaleNurse325]

I could do that but I have 10 colleagues who use the system and they re.. lets say, less that reliable.
Currently the font is light grey and can only be viewed from directly in front of the screen.

 

[missinglinq]

So clear the patient name after the code form printing the label:

Me.Patient = Null

Linq ;0)> (Retired Male Nurse)