Drop down list

[oskar_diaz]

im sorry but im kinda new to access. i have a drop down list that i want to be created. its linked to names of people. Everytime i select a name i need the forms to be cleared. So that new information can be entered. Not sure how to approach it.


Thank you

 

[dcx693]

Do you mean you want the form to go to a new blank record? Try using this
DoCmd.RunCommand acCmdRecordsGoToNew
in the AfterUpdate event of your name list control. If you aren't sure how to assign code like that to events, you should take a look at the Access help.

 

[oskar_diaz]

This is my issue. I have a drop down list with names on the main form. I have various sub forms within this form. I want to be able to select a name and he fields bellow being blank. Thank you for your help.

 

[dcx693]

So, you want the subforms to go to new records? You don't want to search for a previous entry with the username and erase it, right?

If it's the first case, you can make the subforms go to new records by using a variation of the code I first posted. I haven't tried this myself, but I think you can get it to work by using this:
Me.subformname.SetFocus
to move the focus onto the subform, then
DoCmd.RunCommand acCmdRecordsGoToNew