Search results

CJ - Brill All sorted with the below code. My god - I used to know this stuff!!! Back to school for me. Thanks for your prompt response! Dim Category As Integer Category = DLookup("ID", "Tbl_ComponentCategories", "Category = 'Capacitors'") DoCmd.OpenForm "Frm_Browse_Components", , ...

Apologies hit post too quickly.....ive just proved that very point by entering a number....which then passes into the other table so this code works. Thanks. How would I look up a text value in one table and return its ID?

Hi CJ, Thanks for this. I've tried this ans get a runtime error '3434' = Data type mismatch in criteria expression. The field "ComponentCategory" in "Tbl_ComponentDetails" is a lookup list contained in "Tbl_ComponentCategories" therefore making the field classed as a number (i guess it stores...

Good Morning, I am just getting back into using access after 17 years so am very rusty....but I am suprised I'm stuck on this. What I am trying to achieve is that when a user clicks on an image (being used as a command button) in a form it will open up a multiple items form filtering one field...