persistent value in forms

Question

Hello

Greetings!!

First Query

I have a group table and email table.

group table has one field named group name, in the Email table, there is one field group that is bound to group field in group table using combo box.

So each time when user adds emails, group pop ups.

What I want

Since one group refers to many email ids, I want something time saving like

Group form and email form are two different forms whose data goes in different tables namely group and email tables.

So now in ,Email table, lets say I select Group= India from the drop down combo box, for next record, I want to show India pre populated, instead of selecting it again. Some thing like persistent field.

Second Query:

I am using MS Access 2010, and in the form, when I click on Next record, or Next blank record using navigation, the cursor start blinking on second field instead of first field. That may confuse data entry operator.

First field is drop down, and second is simple text box. I think due to first field is drop down, cursor is going to second, I don't want to show the cursor blinking, to avoid confusion.

Thanks in advance.

Regards

Manoj

Answer 1

Please create a new thread with a new question. You may want to substitute (at) for the @ symbol so the data displays correctly.

Answer 2

Dear Sir

Thanks for the reply.

Please help me in doing/putting the code for showing earlier record value as persistent field.

I have another query.

I run the find duplicates query and it gave me result like below.

Email                                 Group

******@xyz.org                      A

******@xyz.org                      B

******@nn.com                      C

******@nn.com                      C

******@dd.net                          D

******@dd.net                          E

I have to delete those record, where Email Id is Same with in Same Group. As per my example, given above, only Email ID ******@nn.com found duplicate with in group C, So I have to keep only single record of it, and delete rest.( why I am writing rest, is, there may be more than 2 records with in the same group having same Email ID.

How to do it using Query

Thanks in advance.

With Regards

Manoj

Answer 3

First possible answer:

You can add a little code in the After Update event of a control to set its Default Value to the current value. This will only affect new records.

Second possible answer:

The Tab order of your controls and Tab Stop properties will typically manage the focus. You can also use code in the On Current event of the form to set the focus to a particular control.