Hi all very new to this so not sure how to code this very well.
I have a database Form "Projects" which has the following fields:
ID
Address
Total Units
Date
Owner
Agent/Source
Terms/Deferment
Planning Permission
Situation
User Initials
Comments
I have two buttons:
Find_Record
Add_Record
I have the following textboxes:
Address
Total Units
Date
Owner
Agent/Source
Terms/Deferment
Comments
I have the following dropdown boxes:
User Initials
Planning Permission
Situation
The dropdown options are:
User Initials - "CJ" "MN" "AR" "JE" "DS"
Planning Permission - "Y" "N"
Situation - "Buying" "Chasing" "Sold" "Offer Submitted" "Offer Accepted" "Option" "Contracted"
I need to code this so when I type in these various textboxes and press "Find_Record" it will search for the relevant criteria of information given in the textboxes.
I also need it so when I press "Add_Record" it will add the information provided into a new project in my "Projects" form.
I am asking for quite a lot, I know but if anyone can help out there it would be AMAZING! I have searched forum after forum after youtube video and I cant get this to work. (pasted code would be amazing!)
PLEASE SOMEONE HELP!
Thanks in advance