Help with Form and combobox

[mari_hitz]

Hi!, I am new in the forum and also new with Access too. I do not know much of VB language and I need help on a form.

I am trying to create a tool to help people to get the requirements they need in order to travel to another country. I have created a table with the information and all the combination of countries, visas types, type of activites they are going to perform etc...
I have created a form with three combobox that contains fields such as: Home Country, Host Country, Type of activity, so the person can filter and choose what they need and then get the information they want.
I have created a buttom to go to another form with the information of the table so the person once that has choosen can go there to see the result. The matter is that when I perform the filters and hit the buttom it goes to the another form with the result but it does not give the combination I have choose.

Do you have any idea on how I can make so the form with the results returns me the combination I have made?


Thanks in advanced!!!

 

[boblarson]

First up would be - how are you opening the second form? What filters are you passing to it and how?

 

[RuralGuy]

You probably need to use VBA code to fill in the next form from the 1st form or reach back into the 1st form from the 2nd form in the OnLoad Event of the 2nd form.

 

[mari_hitz]

Hi! Thanks for the reply!

First up would be - how are you opening the second form? What filters are you passing to it and how?

I am ussing as filters three of the fields that are in the main table ( I actually have one table with all the information). I put a buttom at the bottom of the page in order to people click in there so they can be re-directed to the form with the information they wanted to see according to the combination they have chosen.

You probably need to use VBA code to fill in the next form from the 1st form or reach back into the 1st form from the 2nd form in the OnLoad Event of the 2nd form.

If it does not botter you, could you please let me know how to do that? Maybe it is wrong from me to try to do something like this without any kwnoledge of VB language, but I would like to give it a try.



I was thinking... If I separate the information into two tables: one with the filters of the first form and also with the combination of countries, and then another table with the rest of the information and then I create a relationship with them, the form will return the information with the combination requested due to the connection between them? I do not know if I am explaining my thought correctly but hope you have patience for an Access newbie

 

[RuralGuy]

If you look at the click event code for the button that opens the next form you could post what you have there so we can see it.

 

[mari_hitz]

Hi guys! Thanks a lot for all your replies. This is what I see when I click on the event code:


Option Compare Database
Private Sub Combo0_BeforeUpdate(Cancel As Integer)
End Sub


Here I have some pictures:

Thanks in advanced!

 

[RuralGuy]

It looks like your button is using a Macro without either a WhereClause or OpenArg arguments. Rather that struggle with Macro's I would suggest code in the OnLoad event of the [Imigration Tool] form that looks back at this current form and applies a filter maybe.

 

[mari_hitz]

Hi Guys!

Sorry for not posting again! That data base was put on hold for now. I am working on another one, aaaand I have another question.
If in a table for a same person I have multiple kind of tasks, how can I make so the form of the query can display all those task.
I have made a query based on the table that asks you to insert the name of the person you want to see the task assigned to him/her. When I run the query it returns all the tasks, but when I create a Form based on that query it does not return me all the task in the Form. How can I make to all the tasks to be displayed?