Hello again...nearly the weekend.

within my form I'm trying to create a check box which when selected writes a '0' to my price field, then makes visible a box saying 'Included'

It's a quotation database and sometimes we throw in items for free!!! and say it's included within the price.

Any ideas if it can be done?.

I've managed to get make a text box visible (wow you might say) but not managed to set the price field to zero.

cheers
marcus

Something like this?


ChkBox_OnClick

If ChkBox then
IncludedLabel.Visible = True
TxtPrice = 0
Else
IncludedLabel.Visible = False
Endif

End Sub


Sam, hth

You'll have to include the part about the label visibility in the Form_Current event as well, in order for it to persist, record to record:
Linq ;0)>

thanks for looking into it for me .

That's why we're here!

hi there,

I tried the code but it didn't change the List_Price field. No errors were thrown up, it just didn't change. I've tried writing to the record source but that didn't work either.

I'm thinking i need to update the List_Price field just for that record somehow? Update query? to set it to 0.
cheers
marcus

not quite there.

I've created an update query based on the table which holds the Price_List. I can't seem to reference the current record in my subform. A box pops up asking me to select the record number. Does anyone know how to reference the current record on a subform so I can use it in my query?
cheers
marcus