-
Aug 6th, 2018, 04:14 AM
#1
Thread Starter
Lively Member
match 2 table field then display on textbox1,textbox2,textbox3...
Hi, Good day to all.
can any one help on this ?
i'm using microsoft access 2000, i have 2 database and 2 tables.
table 1 (name : users)
field : usedID,user,salesman,date1
table 2 (name : target)
field : name1,location1,target1,month1,year1
I managed to display table 1 'user' data field on combo1, but how to match the 2 different fields and display the all data field from table 2 on text1,text2,text3,text4.
below code only can display one data record..
how to display all data from table 2, when 2 data field 'user' and 'name1' is match (highlighted RED) ?
Code:
Private Sub combo1.Click()
if combo1.text = rs.fields("name1") then
Text1.text = rs.Fields("target1")
Text2.text = rs.Fields("location1")
Text3.text = rs.Fields("month1")
Text4.text = rs.Fields("year1")
Else
Text1.text = ""
Text2.text = ""
Text3.text = ""
Text4.text = ""
End If
End Sub
-
Aug 6th, 2018, 04:21 AM
#2
Re: match 2 table field then display on textbox1,textbox2,textbox3...
Please don't post the same question multiple times. If you post in the wrong forum then use the Report Post icon under your post to ask the mods to move the existing thread to the correct forum. Now they have to delete your other thread, if they even learn that it exists.
-
Aug 6th, 2018, 04:27 AM
#3
Thread Starter
Lively Member
Re: match 2 table field then display on textbox1,textbox2,textbox3...
-
Aug 6th, 2018, 11:50 AM
#4
Re: match 2 table field then display on textbox1,textbox2,textbox3...
(Probably misunderstanding how you have it...)
Check the properties on the combo box. there is one for column count. Change to the number of columns to use.
Also there is a columnwidths property, change this to something like 0; 1; 1; 1
Change the 1's to appropriate widths. 0 is to hide the first column (usually an id column that the user doesnt need to know)
As to the code, then on the on click or on change event, put
Code:
Text1 = combo1.column(2)
Text1 = combo1.column(3)
The column to get the selected line from (assuming this is what you are asking).
Whats the sql you are using to open for the combo?
or, is the combo just the users.
In which case for the second tables data, use a listbox.
Add a query and add the combos values as the filter/parameter
Is it bound or unbound?
How are you filling / getting the data?
Feeling like a fly on the inside of a closed window (Thunk!)
If I post a lot, it is because I am bored at work! ;D Or stuck...
* Anything I post can be only my opinion. Advice etc is up to you to persue...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|