Recent content by gt11990

Hi pr2-eugin just a quick question is there a way i can modify this code so i can search in multiple tables for example right now it searches just my orders table which is assigned to the form how ever id like it to also search the address from customers table according to the customer id

oh wow yup makes perfect sense thank you so much for your time and efforts very grateful:D

wow thank you so much worked like charm i would ask what the problem was but i dont want to waste your time

thats weird isn't the database attached ?

yup course i have attached the dummy database

ok i have the following fields in the screen shot, its linked to customers table with customer details so in the form i want to just search anything name, id address and once the search is done the results are displayed in the form fields. so far so gd the search works but when you enter...

oh lord this is driving me crazy now i get the following error soo weird

thank you for the code it still searches normally for existing records but none existing still same error please see on attached screen shot

hi there Pat Hartman now i understand how it works may ask you an additional question the look up option which does the combo box how would i implement it in such way for example gets customer ids from the customer details table, the combo box is in orders so when am in orders when i...

ok after closing and reopening the database i get that same message the one in your screen shot but what does it mean i mean how could i solve this problem in the screen shot when i search a record which does not exist i get this error

nothing when i search the right information i can do a search no problem if i leave it blank and search the run tiem error comes up the same one

i did what you said but nothing comes up on the new window when i press the button

oh my am so confused right now is it possible for you to show it just a section of my code so i can understand more clearly thank you

ok thank you i will look into that but like i said i am very new to this its very confusing

hi there i have a search button on the form which does work does the search very well how ever if a wrong search value is entered which does not exist in the database i get the Runtime error "3021" here is my code Private Sub cmdSearch_Click() Dim bkmk As Variant Dim strField As String Dim...