Recipes

Recipe Program
VB 2010
Access 2000
Access is the data source

RecipeRevDataSet
tblRecipes

Form1.vb
When it loads I want to be populated from TypeOfRecipeComboBox from the access table.
That would be on the order of French, Italian, German, Ect.
When I click on the type of recipe it should populate the combo box with the RecipeNameComboBox click on the recipe name and it will show that recipe in IngredientsTextBox and in PreparationTextBox.

I would like to keep it as simple as can be, I'm just starting with VB.:blush:
I also looked in the code area here and didn't see much I understood.:cry:
I do have the form built and the data source done.:afrog:

since you havent asked any questions, i wish you the best in completing your project on time and under budget!!

that's easy enough, but i'd need to see your database to give you a working solution

I tried to compress zip file it and when I try to upload it I get an error (Over 500 MB)
How can I get it here?

you could use a file sharing site:

http://www.mediafire.com/

I hope this will work
2 files one access one VB

this thread reads like a blog post

Lets go at this a different way.
In the Access table I have TypeofRecipe on VB form1 I have TypeOfRecipeComboBox.
On form load how do I get to load all of the types (Italian) into TypeOfRecipeComboBox?
(Mex)
(Cuban)
(French)
When I click on Type of Recipe (Italian,Mex) I want it to load just those of that type into RecipeNameCombo?

you would use the combobox "selectedindexchange" event. Like, after "Mex" was selected then load the other combobox.

Code:

---

        Using da As New OleDb.OleDbDataAdapter("select * from recipes where recipeType=?", yourConnectionString)
            Using dt As New DataTable
                da.SelectCommand.Parameters.AddWithValue("?", comboboxRecipeType.Text)
                da.Fill(dt)
                For Each r As DataRow In dt.Rows
                    yourrecipeComboBox.Items.Add(r("yourfieldname"))
                Next
            End Using
        End Using

---

You'll have to adjust this for your code.

Sorry I didn't get back to this sooner.
I hope these attachments got threw.

Attachment 87581

Attachment 87582

Do you have a question?

your first link/zip file is incomplete + your second link db is also incomplete.
if you upload a db that contains Ingredients and Preparation, i'll write you an example

C:\Users\Games\Desktop\NewFolder(2)
I think that would be the connecting string. That is where I saved it.
Attachment 87591