Change Event (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.

 

[neileg]

It is usual to have two columns in the combo, the first one being the primary key which is hidden and the second a text field that the user sees. You can add more columns though, so I would add ModelNumber & Price to the combo box, but set the column width to zero so they are invisible. Then use the After Update event of the combo to read the data from these two columns and populate your controls on the form where you want the data to display.

 

[asdaqamin]

I am not getting your point. As I am novice.
Can you give me a sample database which doing like this.

On the basis of combo value selection by user the rest of required information shows in text fields.(like Price & Qty).

email: asdaqmalik@gmail.com

 

[asdaqamin]

I am not getting your point. As I am novice.
Can you give me a sample database which doing like this.

On the basis of combo value selection by user the rest of required information shows in text fields.(like Price & Qty).

email: asdaqmalik@gmail.com

 

[neileg]

As I'm feeling generous!

 

[asdaqamin]

The sample you send me was not saving the data,which you supply from form.
Just showing information.
I have attached the my Sample database please figure it out this problem.
If anyone volunterly help me. As this is my school project.

 

[neileg]

I have given you enought information to figure this out. I thought this was an assignment. Assignments should be done by the student. What I would say is that you should not be saving this data except for the MobileID.