Problem with Combo

[asdaqamin]

I have two Tables one relates to Mobile Phone Information & second one relates to Sale Invoice Record.

Mobile Phone Information & Sale Invoice Record Table have relationship of one to many with MobileID.

I dont have expouser of writing codes in VBA.

The problem is that on Sale Invoice Record form. Here we enetered the information about purchased mobile by the customer.
On sale Invoice form. I can access the MobileID in combo. Here all the MobileID(Mobile Phone Information tbl) appears.
But some other Info like ModelNumber & Price how come on the selection of desired MobileID from combo by the User.
(ModelNumber,Price also in the Mobile Information table)

Please guide me what to do & how. Or any example datasebase(link).
It is my own idea that it has to be done with Change Event(combo), You can have more better idea pratically.

I have attached the my Sample database please figure it out this problem.
If anyone volunterly help me. As this is my school project.

 

[CyberLynx]

First off....Think Columns.

Now, this may sound vague to you but you need to realize that we are not going to do your homework for you. You need to figure this out. I have however given you a great tip. Research it and you will be surprised at how fast you pick this one up. Look in the MS-Access Help.

Once you have picked up on this one the rest of what you want to do will come easy.

Please let me know how you do.

.

 

[xcessminds]

Hello asdaqamin

I have made some changes to your attached file for your required features. Take a review and let me know if it works with you.

 

[asdaqamin]

Yeah it is great. I am really thankful to you.
But one thing Qty in the tblMobileInfo not updating after purchasing mobile.
If there are total 20 sets against any MID now if buyer purchased 2 remaining in that Qty will not refelect in tblMobileInfo. It remains same on next purchase.

& one thing when we open the project again. tblMobileInfo Form not showing the purcahsed Model of mobile by the all the Buyers.

Once again very thank you. You acutally got my point.

 

[neileg]

xcessminds - bear in mind the OP is a student and this is an assignment. I have already given him/her enough help to solve the problem on another post but I have not provided the solution.

 

[asdaqamin]

@nelieg

It was a too big project. I have made all the other modules just problem with that part. On the selection of combo.
As you said you are Generous then why you have Jealousy.
I think he done what I want actually.

 

[xcessminds]

Hello asdaqamin!

I agree with @nelieg, he is saying right, if you have this as an assignment then you should try this for yourself , btw the revised file is working fine with me, you should press ">*" before and after entering data

@nelieg, I apologies for the thing you pointed out, you are right and i did this unknowingly as i haven't read the whole query.

 

[CyberLynx]

If he has done what you want my friend....then you have learned nothing. You will learn best by doing this yourself and when you find the solution yourself, you wont easily forget it and you will feel a better person for it.

I don't know everything about Access and will never claim to, but what I do know I have learned on my own. I was never schooled for it. Jealousy plays no part in the scope of things....it's all with your best interest in mind.

.

 

[neileg]

It was a too big project. I have made all the other modules just problem with that part. On the selection of combo.
As you said you are Generous then why you have Jealousy.
I think he done what I want actually.

I'm not trying to be unpleasant. I'm always ready to help and I gave you everything you needed to solve your own problem. What is important here is that you are getting a qualification based on work that you have done yourself. If you don't do the work, why should you get the qualification?

 

[asdaqamin]

By Xaccess Minds:
Take a review and let me know if it works with you

That why I asked I tried to figured out but still fails. The project contains 25 form & similarly 14 tables almost and all done by myself.Similarly quires & reports also.

I am taking help not begging.

 

[xcessminds]

I have checked and its working fine with me, see attached demo.

 

[asdaqamin]

& one thing when we open the project again. tblMobileInfo Form not showing the purcahsed Model of mobile by the all the Buyers.

Once again very thank you. You acutally got my point.

Yeah which you have done is all fine.But pause your demo at time frame 5sec. You will see that before going to adding new records the first records Model number not shown, and similalry rest of.

I have tried alot to do but didnt figure it out.Rest everything is working very fine.

Attached the shot at pausing 5 sec time frame.