I have a task on MS accsess fourm which is doing fourm which contain information about companies like company name,contanct person,telephone,location,fax.
the company name should be on combo box, once i choose the company name,all the information about the company should be retrived from the table ...how can i do this
also, if i have more than one contact person with diffrent information how can i organize it on the fourm, i mean how these diffrent information will be displayed to the user.
I like to link a sub form to the combo box. Once you make a selection in the Combo box, the sub form can display the related data using the Master/Child Linking fields.
Boyd Trimmell aka HiTech Coach
Microsoft MVP - Access Expert
[SIGPIC][/SIGPIC] Office Programming 25+ years as a Software Developer specializing in:
Business Process Management
Accounting/Inventory Control
Customer Relations Management (CRM)
Electronic Data Interchange (EDI)
I have a task on MS accsess fourm which is doing fourm which contain information about companies like company name,contanct person,telephone,location,fax.
the company name should be on combo box, once i choose the company name,all the information about the company should be retrived from the table ...how can i do this
also, if i have more than one contact person with diffrent information how can i organize it on the fourm, i mean how these diffrent information will be displayed to the user.
i opened the attaced file , it is similar to what i want but i want to ask ..
1- when i want to choose something from the database how can i show just 1 item for example just the company name , i dont want all the information to be shown ..
2- how do you link the value that i choose on the combo box to the data that are displayed on the text filed..
i opened the attaced file , it is similar to what i want but i want to ask ..
1- when i want to choose something from the database how can i show just 1 item for example just the company name , i dont want all the information to be shown ..
2- how do you link the value that i choose on the combo box to the data that are displayed on the text filed..
thank you for helping me
Open design form of the sample i attached and see the VBA Code you ill see how this can be done
what does Me refer to and what does the numbers Column(num) refer to
thank you
Okay brother i will try to explain but you will need VBA code tutorials to understand that. microsft access is a module that works with Jet/Ace and Visual basic . Visual Basic contains syntax Code organized to give a certain result you want in certain operation you need. programming codes are complexes but needs dedication to understand. for instance i need to activate a button to transit to the next record i can use Visual basic Code to activate such action as follow
Private Sub NextRecord_Click()
On Error GoTo Err_NextRecord_Click
Expressive code( Me.) you define where the information you take from the combox table will be directed
e.g Me.First Name= cbo combo box.Column(1) that is to say you calling the First name Text box data that is in combo Box in collumn one to be directed to First Name Text Box in your form . if you want to see collumn display your combox in form thrue proprerties in
data in Row Source and click the button at the right hand to display Query builder