Search Problem

[martyloo]

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

[June7]

Check this tutorial about filtering records on form. Note that controls used to input search criteria should be UNBOUND. http://www.datapigtechnologies.com/f...tomfilter.html

If form is bound to table and controls bound to fields, no need for a 'Add Record' button. Record is committed to table when form closes or move to another record. Access Help has guidelines on building bound forms.