Hi,
I have a form which currently imports data which is then left pending until confirmed.
currently i have set the timestamp to the time the record was imported ie =time() in the tables efault value.
I want to change this method so that it time stamps the record upon checking the yes/no confirm box.
this is what ive tried so far,
Me.time.defaultvalue = time() = me.confirm = true
this doesnt work although
Me.update.visible = true = me.confirm = true makes the update command button appear when checked
any ideas?
also how do i bind a text box based on another query not being used by the form,
ie the record source of my form counts all the confirmed fields, i want another count that only counts the confirmed boxes on a certain date on the same form but based on another query.
thx
I have a form which currently imports data which is then left pending until confirmed.
currently i have set the timestamp to the time the record was imported ie =time() in the tables efault value.
I want to change this method so that it time stamps the record upon checking the yes/no confirm box.
this is what ive tried so far,
Me.time.defaultvalue = time() = me.confirm = true
this doesnt work although
Me.update.visible = true = me.confirm = true makes the update command button appear when checked
any ideas?
also how do i bind a text box based on another query not being used by the form,
ie the record source of my form counts all the confirmed fields, i want another count that only counts the confirmed boxes on a certain date on the same form but based on another query.
thx