Blank out name last typed by user in a drop down box

[Jimcb8]

Has anyone been able to figure out a work around to the following issue. Access 2010 leaves the last name that a user typed in after he has done and update. All of the other fields on the form are blanked except the dropdown box .
This seems to confuse my users and they would prefer that the last name is blanked out after an update like all of the other fields. I told them that it is a reminder to them of the last person they updated.

The drop down box has a list of all the clients in the database and the user selects which one they want.

 

[pbaldy]

Sounds like an unbound combo? In the current event of the form:

Me.ComboName = ""

or

Me.ComboName = Null

 

[Jimcb8]

Paul,
Thank you for your response.

This is what I tried to do:
I have a menu called Homepage.
Client Visits is a tab on this menu.
I went to the form property on the form called Client Visit.
on the line
"On Current" I typed
Me.Combo69=""

and saved the result.

access could not find the macro Me

Thanks for your help.

Jim

 

[Jimcb8]

Paul,
I think it works ok.

Now when I type in the name it retrieves the record, but the combo box is immediately blanked out and the data for that client is available for updates.


This is good for me.

Ideally it would be nice if the typed name in the combo box went away after the record was updated and the fields in the record are blanked out. Can that be done?

Thanks so much for your help.

Jim

 

[pbaldy]

What I posted was VBA code, which goes here

http://www.baldyweb.com/FirstVBA.htm

 

[Jimcb8]

Paul,
Thank you for your help on this problem. With your help we are able to feed over 500 people each week.

Thank you so much.

Jim

PS I don't see where I can thank you to add to the many people that you help.

 

[pbaldy]

Happy to help Jim! And your thanks is enough for me.