Recent content by Kev_1988

I've added a picture hope you will understand it better

Hi Is there a way that only open the "Navigation Form" at Form view and nothing more? I know there is a way like Access > options > current database > display form But you can still get access to tables, forms, queries even design view to edit anything. Question, is there a way that you can...

Hi I've created a "frmResult" form, with two combo boxes. Now I've named the first combo box: Product Name Second combo box: Test Sample What I want is in the first combo box: Product Name, selecting only products that's already selecting. But the second one is tricky, for second combo box...

Oke, thanks for your help. Enjoy your holiday:)

Oke that sounds a solution. Can you tell me step by step how to do it? So you telling me I have to deleted the row source code? (aka lookup?) So instead of the numbers i've to fill in like text? Im just a beginner of Access and VBA so please be patient with me:)

I have already created a separated table with SupplierID as primary key see "tblSupplierType" If you mean that? And then I gave Supplier in tblProduct row source like: SELECT [tblSuppliertype].[supplierID], [tblsuppliertype].[suppliertype] FROM tblsuppliertype ORDER BY [SupplierType]; So this...

Can you lead me step by step what I have to do?

Thanks for helping me so far!!:) I got a new question/problem...:confused: Hope you can help me out here I've created a "frmResult" form, with the same principal, two combi boxes. Now I've named the first combo box: Product Name Second combo box: Test Sample What I want is in the first combo...

Hi I've create a form "Test Search" with 6 different search bars so then I can search very specific. If you click on SEARCH button then you will direct to another form with overall overview of products. The problem is under column "Supplier" it only shows numbers 1 till 5 random. But if you...

Thanks a lot!! It works:)

I change the macro in the cboProductTest. If you see the new vba where do I write the requery? Go to form "TestComboBox1 > property sheet cboProductTest > after update I'll add the file so you can see it

The Doc Man can you help me?

I've converted the macro to vba with" Convert form's macros to visual basic" Now there is vba code. But if i changed the query code of the combo box "cboProductTest" from [forms]![TestComboBox1]![cbosuppliertest] to Like "*" & [forms]![navigation...

Oke so technically rowsources and recordscources are all queries? didn't know that. Oke now you saw the form "TestComboBox1" for the second combo box (cboProductTest) I use macro indeed. Don't now how you change to vba code? I want use those 2 combo box to select a product very easy and quick...

But if you look at the attachment file on my first post. Maybe if you look at the file you can explain me better? I don't have query forms. I have only tables and forms. So in my navigation form under tab "Product overview" in property sheet tab Data; Navigation Target Name I've select "SubForm"...