Attachment for my last question

[alpertunga65]

Hi again,

As I see, a lot of members opened my question, but no answer,
so I decided to add a mdb file to make easier the question.

In this database I have forms "Aday_List", "Onaylananlar" and "Meslekler", with 2 subforms, named as "Basvuru alt formu" and "Bolum alt formu" on it.

While the form Meslekler is currrently opened, when I clicked double click the field "Basvuruyapan" on the subform "Basvuru alt formu", it opens the form "Aday_List". On "Aday_List" form, I have a checkbox named as Onay. What I want to do is; when I click "Onay checkbox" the value of AdayAdi must move to the field "Basvuruyapan" on the subform "Basvuru alt formu".
I wanted to do it by using a checkbox, because after clicking Onay checkbox, the value of AdayAdi is dropping from the form "AdayList" and moves directly to the form "Onaylananlar".
Checkbox value on AdayList is always "No" and checkbox value on Onaylananlar is always "Yes" I hope this attachment with the explanation will help you to help me

Could you Show a way to solve the problem? Thanks alot...

 

[Simon_MT]

See if I have this right:

So you have a Occupations form - Candidates form - Approved form.

So you Candidates for Construction or Electrical Engineers and then you approve the Applicant. All you need to do is Set Onay is True / Yes without moving the information into Basvuru table and then create another query seaching the ONAY applicants.

Forgive my attempts to translate Turkish.

Simon

 

[alpertunga65]

Hi Simon,

First of all, Sorry replyins so late. But I was busy so that I haven't joined the forum.
Your Attemps are really good to translate Turkish words. No problem with them. Actually I am sure that you get problem with my English.

I solved my problem. I am still working on my database, if I can finish, I will share it here...

Thanks for your help...


PEACE AT HOME, PEACE IN THE WORLD...
M.KEMAL ATATÜRK