Search results

I uploaded work.accdb

Thanks for your patience. I tried numeric type but what is happening is that access open a text box with the name of choosen record asking for inserting value. When I type it is opening the second form but blank. I would like to avoid to open the dialog box asking for value too. Anyway I tried...

I changed listbox adding ID column (number 7) to a new one Me.listbox.column(7) does not works ID is a numeric type. Can you please write down the code without quote. I tried deleting single quote but still does not works

I tried: DoCmd.OpenForm "My second form", , , "ID = '" & Me.listbox name & "'" if that was you meaning. But it is not working. Maybe I mistake code. I'm very poor in code! Thanks for your reply

The name "customers" Anyway there is a fileed ID in the table but I'm assuming "customers" in the code if is that you mean

I use: DoCmd.OpenForm "My second form", , , "Customers = '" & Me.listbox name & "'" for open a second form from a list box . It is working but when I open the second form it opens the first record of same customer name. In example: Marion Bette Marion Dave Marion Junior When I click on on...