Jaydub1991
New member
- Local time
- Today, 07:59
- Joined
- Sep 21, 2021
- Messages
- 10
Hello all,
I'm new around here and have a fair knowledge of Excel and Access but VBA is not quite my friend yet!
I can put together something that has lots of nice and simple features I would say I'm verging on intermediate but not quite pro.
Long and short of it, I have an Access Database which I have put together with multiple tables and multiple forms to pull data from each of these tables.
Now I am trying to build a Search form so I can Search by either the Name or Postcode (Zip Code for my American cousins)
So Far I have a Search function with a list box which will populate based on the persons Name only ( I have also added in an 'after event' so it auto populates) but I cannot get this to multifunction and allow either name or postcode search it will only search by name.
I would also like to be able to double click on one of the results and click through to the entry on the Report form.
Whether it would be possible to Search multiple forms from one Search box without joining all the tables/ Forms together.
Any help would be Very Greatly appreciated.
I'm new around here and have a fair knowledge of Excel and Access but VBA is not quite my friend yet!
I can put together something that has lots of nice and simple features I would say I'm verging on intermediate but not quite pro.
Long and short of it, I have an Access Database which I have put together with multiple tables and multiple forms to pull data from each of these tables.
Now I am trying to build a Search form so I can Search by either the Name or Postcode (Zip Code for my American cousins)
So Far I have a Search function with a list box which will populate based on the persons Name only ( I have also added in an 'after event' so it auto populates) but I cannot get this to multifunction and allow either name or postcode search it will only search by name.
I would also like to be able to double click on one of the results and click through to the entry on the Report form.
Whether it would be possible to Search multiple forms from one Search box without joining all the tables/ Forms together.
Any help would be Very Greatly appreciated.