Clear Part of Screen?

[alexkong2003]

Hi all,

I have a form that let the user to select a training and add trained employee one by one to the database. but i have a problem here, (pls refer to the attachment, thanks). on top part (Training course) i let the user choose the training course then i lock it, after that user start to select the specify employee to the training course, but what i need is when i click the add button then all the record to the database(works good), then the bottom part is cleared and let user to select another employee with keeping the top part details. Any Idea?

Really appreciated if someone can help.

Thanks

alex.

 

[Michael J Ross]

I use a macro to do something similar. I use SetValue to set the value of the text box to null. Add a line after your Save with the command DoCmd.RunMacro "nameofmacro".

Somebody else may be able to do it without macros.

 

[alexkong2003]

i do quite similar as u as well michael.... but i use module to complete it. Actually i use quite a stupid and simple way to do it... haha~~~ i return the top value to string, set the bottom to null and rewrite the value to the top again... Then i made it ... now i wonder is there anybody got another better way to do it?...

Thanks anyway for sharing.

regard,
alex