Solved How can I search for the name based on the master key? A numeric code for the name through ComboBox

[SalmanZeiad]

?

 

[arnelgp]

is your question the Title?
you can use the combo's AfterUpdate event:

private sub combo_afterupdate()
if [combo].listindex > -1 then
    with me.recordsetclone
        .findfirst "[pkFieldName] = " & [combo]
        me.bookmark = .bookmark
    end with
end if
end sub

 

[SalmanZeiad]

is your question the Title?
you can use the combo's AfterUpdate event:

private sub combo_afterupdate()
if [combo].listindex > -1 then
    with me.recordsetclone
        .findfirst "[pkFieldName] = " & [combo]
        me.bookmark = .bookmark
    end with
end if
end sub

i want no duplicate for name depending on id

 

[arnelgp]

normally on Main table you don't do like that (see form 1).
you need another table, a transaction in which you can add New Name to the table (see Transaction form).

 

[gemma-the-husky]

add an index to the table that prevents duplicated names. Then you won't be able to add a new name, or amend a name in a way that would cause a duplicate. How you handle this is a different mater.

 

[SalmanZeiad]

normally on Main table you don't do like that (see form 1).
you need another table, a transaction in which you can add New Name to the table (see Transaction form).

Wow Wow Wow>>>thank you sir