Hello guys ,
I have a button in a form which i use it to transfer data to appending query ( i mean when i click on my button the data in my form transferred to another form and query) but i face some problems and i hope to find solutions, when i click on this button the data transferred successfully, but if i click on it again its added again , which is wrong , i want to avoid this duplication, is there anyway to lock this button to be one time usage only , in more details when i click it ones the data transferred , if i click it again i dont wanna any action to happen
I have a button in a form which i use it to transfer data to appending query ( i mean when i click on my button the data in my form transferred to another form and query) but i face some problems and i hope to find solutions, when i click on this button the data transferred successfully, but if i click on it again its added again , which is wrong , i want to avoid this duplication, is there anyway to lock this button to be one time usage only , in more details when i click it ones the data transferred , if i click it again i dont wanna any action to happen