how to set a data source for a combo box with macro and not with vba

[mana]

can you see it?

 

[mana]

Hello
Could you see the uploaded DB?

 

[khurram7x]

You could indeed setup a criteria in web database. You were making a mistake. I've used Query1 for your solution, and check it works now. You were using Query2, I have left it as it is to find your mistake. Could you get it??

Thanks vbaInet, for backing me up and getting the database uploaded. I'm currently working on VBA and expecting for help from this forum, but I had an interest in Macro's so got a bit hold of them as well, and wanna keep this hold )

 

[mana]

hello

thank you very much from both of you for your help
thank you
i got it and it works now

i have also another problem
i upload it
i want to get the name of the userid in a text box in form2 in main form. but i will get the id of the user instead of the name of the user
i used the rule like issue_new form but i don't know why it doesn't work
thank you for your help

 

[mana]

i really can't understand it why it doesn't work.
and why they user tempuserid in issuesnew form tempuserid?
thank you

 

[khurram7x]

you've not made your situation clear. As i see in Form2, you've assigned Default Value for this field in properties as '=[TempVars]![tmpUserID]'. If you're assigning ID, then how do you expect actual name in place of ID.

another thing is, it happens in case where you refer ID (primary key) with another column in the table, and in this case you might have referred it with column 'Name'. So when you try to get the value of this Name field, you only get the ID number because it appears as text but in background works as a number ID.

Again, your question is not clear and columns/forms you refer in database are not present in sample database. I suggest you post a new question, with more clarity. This way you'll get more attention.

 

[aubrey1983]

1) Setup these two fields as lookup fields
2) Use combo box as its controls and set the Parent Control property. this is where you relate the combo box 2 to your combo box 1.

Hope that helps

 

[aubrey1983]

Hi,

Try checking this video. https://www.youtube.com/watch?v=FdDlnLAGRvM

hope it helps.