Hi, I'm looking for some advice as to what I'm trying to do is possible. I have a
database that pulls data in and allows yields to be checked each hour and displayed on a form, this part seems ok.
What I was trying to do was add a field for comments that could be added for any issues that hour,
I've added an unbound textbox to the form , the issue is that when the form requeries and refreshes all the unbound
comment fields show the same data. I had thought of instead of a blanket me.requery me.refresh on the form to only try and refresh
the textboxes that change , so I tried using
Forms!qrypassHV9002_k1!Pass.Requery
Forms!qrypassHV9002_k1!Pass.Refresh
to try and just requery/refresh the textbox called Pass(if this had worked I'd have used this on the other textboxes to requery)
but this gives an error for the refresh part RTE 438 Object doesn't support this property or method. I also tried a sub form , but this
wouldn't allow the main form to be continuous
I've attached the DB as I thought it might be easier to see than explain. I'm just looking to refresh the fields but keep any comments in the appropriate text box
any ideas would be welcome and appreciated....
database that pulls data in and allows yields to be checked each hour and displayed on a form, this part seems ok.
What I was trying to do was add a field for comments that could be added for any issues that hour,
I've added an unbound textbox to the form , the issue is that when the form requeries and refreshes all the unbound
comment fields show the same data. I had thought of instead of a blanket me.requery me.refresh on the form to only try and refresh
the textboxes that change , so I tried using
Forms!qrypassHV9002_k1!Pass.Requery
Forms!qrypassHV9002_k1!Pass.Refresh
to try and just requery/refresh the textbox called Pass(if this had worked I'd have used this on the other textboxes to requery)
but this gives an error for the refresh part RTE 438 Object doesn't support this property or method. I also tried a sub form , but this
wouldn't allow the main form to be continuous
I've attached the DB as I thought it might be easier to see than explain. I'm just looking to refresh the fields but keep any comments in the appropriate text box
any ideas would be welcome and appreciated....