refresh button on form that views as split form

Question

Hi

I have a form that views as a split form, with the datasheet view on the bottom of the form.  In the top section I have txt boxes created in order to use as an unbound form to enter data into, which my query then reads from and returns the subset of data that I want, this is displayed in the bottom of this form in the datasheet view.  so this form has the record source of my query. this is all good and works fine... here is the  problem...

when I use the default refresh button at the top of access in the "quick access toolbar" it works great, and it runs the query and displays the results in the bottom of my split form in datasheet view.  so I created a button on my split form "refresh" from the create button in design view, and it doesn't work at all.  I then did some fiddling around with some macros, but to no avail.

can someone point me in the right direction please to get this working.

form name: frmTransmittalFilter

query name: qryFilter_For_Transmittals

the form frmTransmittalFilter is based n the qryFilter_For_Transmittals as the record source.  It is a split form, with unbound txt boxes up the top to enter the criteria to return the subset of data that I require, and the bottom of the split form is datasheet view, which displays the records, but I am wanting to hit the refresh button to update the results in this datasheet view, which as I previously said works perfectly in the "quick access toolbar", but when I created my own refresh button on the form it does nothing.

so the objective is to get this refresh button to work on my form.

thanks

Answer 1

You do not want to open the query again.  All you want to do is requery the form.  In VBA code this would be:

    Forms!frmTransmittalFilter.Requery

In a macro, the action would be:

    SelectObject

        Object Type: Form

        Object Name: frmTransmittalFilter

        In Database Window: No

    Requery

         Control Name: (leave blank)

Answer 2

Dirk,

thanks so much .... I used the Macro action and it works perfectly.

Many Hugs and Kisses

thanks

Answer 3

hmmm yeah that sounds about right.

My code executes a query, so yeah I guess your right.

Not familiar with this process, how do I go about it?  I tried doing a macro that I thought would work, by opening/ running the query and closing and opening it again, this did work but it opened the query in a new tab, where as I want the query to update the information in my form that is already open and my datasheet view down the bottom where my results are.

form name: frmTransmittalFilter

query name: qryFilter_For_Transmittals

Here is my SQL

PARAMETERS Forms!frmTransmittalFilter!txtAndtraTransmittalDate DateTime, Forms!frmTransmittalFilter!txtAndtraDateCreated DateTime;

SELECT tblTracking.traDocNo, tblTracking.traRevNo, tblTracking.traOwner, tblTracking.traRevisionDate, tblTracking.traStatus, tblTracking.traSentReceived, tblTracking.traToFrom, tblTracking.traCompany, tblTracking.traTransmittalDate, tblTracking.traTransmittalNo, tblTracking.traNotes, tblTracking.traDateCreated, tblTracking.traSelect, tblDocuments.docTitle

FROM tblDocuments LEFT JOIN tblTracking ON tblDocuments.docDocNo = tblTracking.traDocNo

WHERE ((tblTracking.traDocNo Like "*" & Forms!frmTransmittalFilter!txtdocDocNoFrom_Update & "*" Or Forms!frmTransmittalFilter!txtdocDocNoFrom_Update Is Null)

And (tblTracking.traDocNo<=Forms!frmTransmittalFilter!txtdocDocNoTo_Update Or Forms!frmTransmittalFilter!txtdocDocNoTo_Update Is Null))

And (tblDocuments.docTitle Like Forms!frmTransmittalFilter!txtAnddocTitle & "*" Or Forms!frmTransmittalFilter!txtAnddocTitle Is Null)

And (tblTracking.traRevNo Like Forms!frmTransmittalFilter!txtAndtraRevNo & "*" Or Forms!frmTransmittalFilter!txtAndtraRevNo Is Null)

And (tblTracking.traStatus Like Forms!frmTransmittalFilter!txtAndtraStatus & "*" Or Forms!frmTransmittalFilter!txtAndtraStatus Is Null)

And (tblTracking.traOwner Like Forms!frmTransmittalFilter!txtAndtraOwner & "*" Or Forms!frmTransmittalFilter!txtAndtraOwner Is Null)

And ((tblTracking.traRevisionDate>=Forms!frmTransmittalFilter!txtAndtraRevisionDate And tblTracking.traRevisionDate<Forms!frmTransmittalFilter!txtAndtraRevisionDate+1) Or Forms!frmTransmittalFilter!txtAndtraRevisionDate Is Null)

And (tblTracking.traSentReceived Like Forms!frmTransmittalFilter!txtAndtraSentReceived & "*" Or Forms!frmTransmittalFilter!txtAndtraSentReceived Is Null)

And (tblTracking.traToFrom Like Forms!frmTransmittalFilter!txtAndtraToFrom & "*" Or Forms!frmTransmittalFilter!txtAndtraToFrom Is Null)

And (tblTracking.traCompany Like Forms!frmTransmittalFilter!txtAndtraCompany & "*" Or Forms!frmTransmittalFilter!txtAndtraCompany Is Null)

And ((tblTracking.traTransmittalDate>=Forms!frmTransmittalFilter!txtAndtraTransmittalDate And tblTracking.traTransmittalDate<Forms!frmTransmittalFilter!txtAndtraTransmittalDate+1) Or Forms!frmTransmittalFilter!txtAndtraTransmittalDate Is Null)

 And (tblTracking.traTransmittalNo Like "*" & Forms!frmTransmittalFilter!txtAndtraTransmittalNo & "*" Or Forms!frmTransmittalFilter!txtAndtraTransmittalNo Is Null)

 And (tblTracking.traNotes Like "*" & Forms!frmTransmittalFilter!txtAndtraNotes & "*" Or Forms!frmTransmittalFilter!txtAndtraNotes Is Null)

 And ((tblTracking.traDateCreated>=Forms!frmTransmittalFilter!txtAndtraDateCreated And tblTracking.traDateCreated<Forms!frmTransmittalFilter!txtAndtraDateCreated+1) Or Forms!frmTransmittalFilter!txtAndtraDateCreated Is Null)

ORDER BY tblTracking.traDocNo;

Answer 4

What macro or code does your refresh button execute?  I would think that it needs to execute a Requery action, not a Refresh action.

Answer 5

Can someone help me? please