Help I dunno y it doesnt work

[zaza123]

I wanna create a access form with a save button which will save the data keyed in the listbox & textbox onto a microsoft access table. I would also need a filter button from the form which will filter what ever data is keyed in the list box & textbox and appear in the microsoft access table....I cant seem to get both of them to work....Im kinda new to Access so yeah & my programming aint good..

[June7]

Bind the form to the table, bind controls to the fields, whatever is entered into the controls is entered directly to table. Don't understand what you mean by 'will filter what ever data is keyed in the list box & textbox and appear in the microsoft access table'. Show the code you have written so far.

[zaza123]

What i mean is...when i have key in any data in the list box or the textbox, when i press the button, it will look through the table which i have all my data and show those that match with the data inputed in my listbox & textbox....the similar data will appear in another table....

[June7]

Don't try to programatically filter directly on table. Use a form that is bound to the table. Open the form with filter criteria. Click button on first firm to run code that will open second form with filter criteria:
If Not IsNull(Me.textbox) And Not IsNull(Me.listbox) Then
DoCmd.OpenForm "formname", , , "fieldname1='" & Me.textbox & "' AND fieldname2='" & Me.listbox & "'"
Else
MsgBox "Must enter criteria in both textbox and listbox."
End If

[zaza123]

Sorry I still dont understand so i will have 2 forms am i right...And to bound the table to form , and field to table, all u have is adjust from the control source right???(Sorry im kinda new at access so im super blur...Thx alot for ur help & patience)

[zaza123]

This is what i have done so far!!!

[June7]

Okay, that is working. You use Embedded Macro. The code sample I gave is VBA code, but should be able to replicate in macro.

Code could open another form that displays all records with the matching values from first form. However, can't use bound controls to enter a criteria to search for, this would change the value in the table record.

[zaza123]

Thx Alot June ill try to solve the rest thx!!!!