Automatic Display...

[PedRocK]

HI,
Im using Access 2003

Check the Attached File,

In the frm_Client there is a comboBox Client Name where its taking values from tbl_clients.I'm adding New Client Names with the command button "+"which is opening frm_AddClient so that i add new client Name.

In this new opened form i am entering new Name then clicking the command "Return" button to refresh and return to the previous form, then i'm selecting my new added client. im doing here 4 steps where i can reduce it into 2.

In the new opened form "frm_AddClient" I want to Type a name then Enter to return to the Main form where i want to see the Last value i typed is Automatically displayed in the combo box and the cursor is moved down to the next textbox.

Can anyone Help me doing this please.

Thanks

 

[Uncle Gizmo]

Not in List Event

A better way would be to use the "not in list " event . you would use this in your combo box , when an entry is entered into the combo box that is not in the list this event fires . It's not quite as simple as that, I suggest you search through the forum for posts on this subject and if you have any questions post them here.

 

[PedRocK]

maybe you didnt got my question..

Command button opening new form...then text entry then command button returning to the main form....when returning what i want is to see the text i entered is displayed automatically in the combo box, and not to pick it up again from its list. plus if i can reduce the command button Return with Enter

 

[Uncle Gizmo]

>>>>> im doing here 4 steps where i can reduce it into 2.<<<<<

What I got from your question was that you wanted to reduce the number of steps needed to enter a new customer if that customer did not appear in the list in your combo box.

This is a very common problem, most databases need something akin to this functionality, so it has already been solved!

The way to do it is by using the "not in list" event on your combo box, you can have this event trigger the loading of your new customer form. You can enter your customer details, and have it coded to automatiaclly return to your form refresh the combo box and display the new customer. You do not need a command button to take you to your new customer form! What could be better. Why reinvent the wheel, why not use what is tried and tested.