Please Save My Soul...

[darno]

Hi,

I have made 3 forms, details,master, and stocks. They r based on same name tables i.e., details, master and stocks.

Stocks has got a set of pre-loaded records. I want to show data related to stocks on details form, but it should only happen when anyone enters some data in a CODE field on details form. Basically there are 3 fields which are same in details and stocks. CODE (NUM), PONO (TXT), DESC (TXT).

My query is, that when a user enters a record in CODE field it should check if the same code exist in stocks table. If yes then it should fetch the other two fields data and paste in details form. Also advise me how to link these three table together. Please Help

 

[Mile-O]

If you want your soul saved then I suggest a church may be the place to go. If you have a problem with Access then I suggest you choose one forum to post your question only once and give it a meaningful title. I, and I'm sure others, am annoyed that I had to open this thread in order to find out it was nothing to do with breaking up a Faustian pact.

Multiple postings of the same question are a waste of our members' time and are not smiled upon. Please bear this in mind.

 

[modest]

I agree. Please note that if you don't follow forum etiquette you can be banned. This includes using misleading titles, wasting users/moderators time, and blatent disregard of respect.

No one is being paid to help so please be considerate. Don't forget, no one's problem is more important than anyone else's --- except for mine