Filter form to only show true\false records

[tweety]

Hi

I need some guidelines or the theory on how to show all the records that haven been paid for. I have a form with 2 subforms, on the first subform the is a tickbox that shows if a order is paid for of not, the second subform shows the details of the order.

I was thinking to have 2 option buttons saying show paid orders and show un-paid orders on the form. or is there a better way?? what is the theory behide this??
the attach below shows the form where the paid check box is and the 2 options buttons (are or will go)





Thanks

[alcapps]

yes.. if that is your method of choice.. I would do it with a combo box.

choices .. all,paid, unpaid
default= 0
three fields tied to field 1
0;ALL;FALSE
1;PAID;TRUE
2;UNPAID;False

field widths 0;2;0
column counts 3

on events of the combo box .. after update

you can set the filter of the main form or you can change the record source it's up to you
I usually change the record source
if me.comboboxname <> 0 then
me.RecordSource = "select * from yourtable where checkfieldname = " & me.comboboxname.column(2)
else
me.RecordSource = "select * from yourtable "
end if
me.requery

[tweety]

Hi
I have added a new combox box and typed the values in the wizard (All, Paid & Un-Paid)

Hm where do i put these 3 lines of code:
0;ALL;FALSE
1;PAID;TRUE
2;UNPAID;False

After putting the code in shown below, (after update event)
the debug is saying there is something wrong in the middle line? (Bold, underlined below)

Private Sub ComboPaymentFilter_AfterUpdate()
If Me.ComboPaymentFilter <> 0 Then
Me.RecordSource = "select * Sales.Paid = " & Me.ComboPaymentFilter.Column(2)
Else
Me.RecordSource = "select * Sales "
End If
Me.Requery
End Sub

[alcapps]

can you post your database just a table with sample data and that form.. in it..

[alcapps]

what do you have for your row source in your combo box..

and in me.recordsoruce = "select * From sales"

[alcapps]

me.recordsource = "select * from sales where paid = " & me.comboboxname.column(2)

[alcapps]

when you setup a combo box.. you can select type my own values..

you need 3 columns

0;ALL;FALSE
1;PAID;TRUE
2;UNPAID;False

[tweety]

i have taken out all the extra bits to the database the form i added the code into is record customer sales....

thanks

[tweety]

oh ok, i did type the values in but didnt add the numbers below the values

[tweety]

i just tried the way you said to type the values in with 0, 1 and 2 in front but that shows in the list box too?

when you setup a combo box.. you can select type my own values..

you need 3 columns

0;ALL;FALSE
1;PAID;TRUE
2;UNPAID;False

[alcapps]

Sweet Temptations - Copy.zip

ok got it to work.. but you have many things that were not setup right.. take a look..

I would change the form to show second form inside that form to show all the transactions..

then sales inside another form.. that way you would have a datasheet view of all sales by customer.. then clicking on that sale would give you the details.

anyway this works.. check it out..

[tweety]

can you explain abit more what iv setup wrong please?

and i didnt understand the the form view you mentioned, can you please explain abit more

thanks

[alcapps]

yes.. you entered a single line of input in your combo box.

Hm where do i put these 3 lines of code:
0;ALL;FALSE
1;PAID;TRUE
2;UNPAID;False

when entered into the combo box source
it should have been like this
0;ALL;FALSE;1;PAID;TRUE;2;UNPAID;False

column count should have been 3 not 1
I changed the false to 0 and true to -1

in your filter button after update.
you were pointing to the main form

you were trying to change the records of the sub form

you left out the from sales in the record source

you can go to microsoft and look at templates of sales they have a better explanation than I can give you.
Look at their example and try to use them.

http://office.microsoft.com/en-us/te...2Db8e6b8350a15